Re: synchronized snapshots

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

In response to

Responses

Browse pgsql-hackers by date

  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