On 1/1/08, kenneth d'souza <[EMAIL PROTECTED]> wrote:
> I am trying to understand concurrency and mvcc with a small example in
> psql.
Note that the big advantage to MVCC is that writers do not block
readers. Since your example consists of all writers, MVCC isn't doing
much for you.
> Isolation
On Tue, Jan 01, 2008 at 01:02:42PM +, kenneth d'souza wrote:
> I am trying to understand concurrency and mvcc with a small example in
> psql.
I don't think your example below really shows MVCC working. MVCC is a
behind the scenes implementation detail that if you're just typing SQL
commands y
Hi,
I am trying to understand concurrency and mvcc with a small example in
psql.Isolation_level is read commited. There are 4 psql session by the same
Role. I am executing the commands in the below sequence.
Session 1:insert into kentab values ( 1,'A');commit;
begin;update kentab set name='
