Re: Proposal for CSN based snapshots - Mailing list pgsql-hackers

From Ants Aasma
Subject Re: Proposal for CSN based snapshots
Date
Msg-id CA+CSw_uqc83RC3R4mMEHAzqPjEQmVquh_5XHG_tTQx3T43ahww@mail.gmail.com
Whole thread Raw
In response to Re: Proposal for CSN based snapshots  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
On Mon, May 12, 2014 at 7:10 PM, Greg Stark <stark@mit.edu> wrote:
> Would it be useful to store the current WAL insertion point along with
> the "about to commit" flag so it's effectively a promise that this
> transaction will commit no earlier than XXX. That should allow most
> transactions to decide if those records are visible or not unless
> they're very recent transactions which started in that short window
> while the committing transaction was in the process of committing.

I don't believe this is worth the complexity. The contention window is
extremely short here.

Regards,
Ants Aasma
--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: cannot to compile PL/V8 on Fedora 20
Next
From: Rohit Goyal
Date:
Subject: Running DBT2 on postgresql