Re: Serializable Snapshot Isolation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Serializable Snapshot Isolation
Date
Msg-id 16766.1285425928@sss.pgh.pa.us
Whole thread Raw
In response to Re: Serializable Snapshot Isolation  (Greg Stark <gsstark@mit.edu>)
Responses Re: Serializable Snapshot Isolation
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> On Thu, Sep 23, 2010 at 4:08 PM, Kevin Grittner
> <Kevin.Grittner@wicourts.gov> wrote:
>> One place I'm particularly interested in using such a feature is in
>> pg_dump. Without it we have the choice of using a SERIALIZABLE
>> transaction, which might fail or cause failures (which doesn't seem
>> good for a backup program) or using REPEATABLE READ (to get current
>> snapshot isolation behavior), which might capture a view of the data
>> which contains serialization anomalies.

> I'm puzzled how pg_dump could possibly have serialization anomalies.

At the moment, it can't.  If this patch means that it can, that's going
to be a mighty good reason not to apply the patch.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: What happened to the is_ family of functions proposal?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Serializable Snapshot Isolation