From: | Joachim Wieland <joe(at)mcknight(dot)de> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: synchronized snapshots |
Date: | 2011-09-14 02:37:56 |
Message-ID: | CACw0+13o_UitPBYwKv0ceFOgUfn=LQWR29Qq3oKBuHj7wfB1AQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, Aug 14, 2011 at 9:31 PM, Joachim Wieland <joe(at)mcknight(dot)de> wrote:
> This is a patch to implement synchronized snapshots. It is based on
> Alvaro's specifications in:
>
> http://archives.postgresql.org/pgsql-hackers/2011-02/msg02074.php
Here is a new version of this patch, what has changed is that the
snapshot is now imported via:
BEGIN
[... set serializable or read committed on the BEGIN or via SET TRANSACTION ...]
SET TRANSACTION SNAPSHOT '00000801-1'
This way any failure importing the snapshot leaves the transaction in
the aborted state.
I am also attaching a small perl script that demonstrates a
serialization failure with an imported snapshot.
This is the link to the previous patch:
http://archives.postgresql.org/pgsql-hackers/2011-08/msg00684.php
Joachim
Attachment | Content-Type | Size |
---|---|---|
syncSnapshots.2.diff | text/x-patch | 45.9 KB |
test-ssi.pl | text/x-perl | 1.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | David E. Wheeler | 2011-09-14 05:24:27 | Re: What Would You Like To Do? |
Previous Message | Kyotaro HORIGUCHI | 2011-09-14 02:26:51 | [REVIEW] Generate column names for subquery expressions |