| From: | Ants Aasma <ants(at)cybertec(dot)at> |
|---|---|
| To: | Greg Stark <stark(at)mit(dot)edu> |
| Cc: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>, Ants Aasma <ants(at)cybertec(dot)at>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Markus Wanner <markus(at)bluegap(dot)ch> |
| Subject: | Re: Proposal for CSN based snapshots |
| Date: | 2014-05-12 17:06:39 |
| Message-ID: | CA+CSw_uqc83RC3R4mMEHAzqPjEQmVquh_5XHG_tTQx3T43ahww@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, May 12, 2014 at 7:10 PM, Greg Stark <stark(at)mit(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rohit Goyal | 2014-05-12 17:16:16 | Running DBT2 on postgresql |
| Previous Message | Peter Eisentraut | 2014-05-12 17:04:18 | Re: cannot to compile PL/V8 on Fedora 20 |