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 allI 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
Wed, 19 Mar 2003 8:20:23 +0800
postgresql <postgresql@db.pku.edu.cn>
mvcc and lock
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



Wed, 19 Mar 2003 07:30:14 +0100
Ronald Kuczek <ronald@breitenbach.pl>
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?
> 
> http://archives.postgresql.org
> 

-- 
  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

Wed, 19 Mar 2003 09:34:27 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Win32 native port
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?
> >
> > http://archives.postgresql.org
> >
>
> --
>   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


Thu, 20 Mar 2003 09:31:52 +0100
"Ronald Kuczek" <ronald.kuczek@breitenbach.pl>
Re: Win32 native port