mvcc and lock
Hi all
I have read some code on transaction part.
When the new transaction starts, it record the snapshot of database containing the current transaction id,etc. So depending on the snapshot
, the transaction decide which tuple is visible.
But transaction could also be implemented by lock. so I am not sure how
the transaction is implemented, by MVCC or Lock, or by both?
In my option, when tuple is processed in readonly mode(select), MVCC is enough. but when tuple is changed, lock is used. I am not sure whether the explanation is correct.
Thanks for any comments.
Best regards.
josh
Hi all,
Can someone tell me what happened with Win32 native port ?
Discussion bevore beginning of 7.4, TODO entry this time as "urgent",
but without dash. What does it mean - comes native port with 7.4 or it
doesn't ? Thanks for any information.
Best regards
Rony
I will start working on it next week.
---------------------------------------------------------------------------
Ronald Kuczek wrote:
Hi all,
Can someone tell me what happened with Win32 native port ?
Discussion bevore beginning of 7.4, TODO entry this time as "urgent",
but without dash. What does it mean - comes native port with 7.4 or it
doesn't ? Thanks for any information.Best regards
Rony---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
Thank you, Bruce for info.
Best regards
Rony
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Ronald Kuczek" <ronald@breitenbach.pl>
Cc: <pgsql-hackers@postgresql.org>
Sent: Wednesday, March 19, 2003 3:34 PM
Subject: Re: [HACKERS] Win32 native port
I will start working on it next week.
--------------------------------------------------------------------------
-
Ronald Kuczek wrote:
Hi all,
Can someone tell me what happened with Win32 native port ?
Discussion bevore beginning of 7.4, TODO entry this time as "urgent",
but without dash. What does it mean - comes native port with 7.4 or it
doesn't ? Thanks for any information.Best regards
Rony---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania
19073
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.463 / Virus Database: 262 - Release Date: 17.03.2003