Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Andrew Sullivan <ajs(at)commandprompt(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot"
Date: 2008-05-21 01:51:43
Message-ID: 1211334703.4082.17.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Tue, 2008-05-20 at 17:04 -0400, Andrew Sullivan wrote:
> On Tue, May 20, 2008 at 08:56:41PM +0200, Ivan Sergio Borgonovo wrote:
>
> > I just would like to have a coherent snapshot of some tables.
>
> If you have a multi-statement transaction, then if you are in READ
> COMMITTED you can see changes, and if you are in SERIALIZABLE you
> can't.

Unless the changes were made by yourself in the top-level transaction or
an un-aborted subtransaction, in which case they are visible.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gurjeet Singh 2008-05-21 02:56:27 Re: pg_standby stuck on a wal file size <16MB
Previous Message Vlad Kosilov 2008-05-20 22:44:27 Re: pg_standby stuck on a wal file size <16MB