Postgres Pro
Downloads
Home   >   mailing lists

Thread: mvcc and lock

mvcc and lock

From
postgresql
Date:
Hi all<br />I have read some code on transaction part.<br />When the new transaction starts, it record the snapshot of
databasecontaining the current transaction id,etc. So depending on the snapshot<br />, the transaction decide which
tupleis visible.<br />But transaction could also be implemented by lock. so I am not sure how <br />the transaction is
implemented,by MVCC or Lock, or by both?<br />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.<br />Thanks for any
comments.<br/>Best regards.<br />josh

Win32 native port

From
Ronald Kuczek
Date:
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

Re: Win32 native port

From
Bruce Momjian
Date:
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,
Pennsylvania19073

Re: Win32 native port

From
"Ronald Kuczek"
Date:
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