-----Original Message-----
From: Jon Grov [mailto:jon@linpro.no]
Sent: Friday, April 05, 2002 12:54 PM
To: Dann Corbit
Cc: Mike Mascari; Doug McNaught; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Suggestion for optimization
"Dann Corbit" <DCorbit@connx.com> writes:
> That's interesting. If Oracle is a MVCC database, how did they
> manage to perform ANSI standard Isolation Levels? It seems it ought
> to be impossible.
There's an excellent introduction to MVCC and snapshot isolation in
the PostgreSQL docs.
See
http://www2.no.postgresql.org/users-lounge/docs/7.2/postgres/mvcc.html
>>------------------------------------------------------------------
I have read these documents (and some others) now. It seems that
there is a serializable transaction level, and so the goal I was
after can be reached anyway. So never mind. I am at peace again
(and breathing a heavy sigh of relief).
But I am a bit puzzled. How can a serializable transaction be
performed in a MVCC system? I realize the Oracle does it, and also
Postgresql, but I can't picture how that would work.
<<------------------------------------------------------------------