Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> Could someone describe concisely what behavior "snapshot" isolation
> provides that repeatable read does?
Phantom reads are not possible in snapshot isolation. They are
allowed to occur (though not required to occur) in repeatable read.
Note that in early versions of the SQL standard, this difference was
sufficient to qualify as serializable; but recent versions raised
the bar for serializable transactions.
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2009-05-28 15:02:13|
|Subject: Re: Clean shutdown and warm standby|
|Previous:||From: Greg Stark||Date: 2009-05-28 14:57:11|
|Subject: Re: User-facing aspects of serializable transactions|