Re: Proposal for CSN based snapshots

Поиск
Список
Период
Сортировка
От Ants Aasma
Тема Re: Proposal for CSN based snapshots
Дата
Msg-id CA+CSw_uqc83RC3R4mMEHAzqPjEQmVquh_5XHG_tTQx3T43ahww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposal for CSN based snapshots  (Greg Stark <stark@mit.edu>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: cannot to compile PL/V8 on Fedora 20
Следующее
От: Rohit Goyal
Дата:
Сообщение: Running DBT2 on postgresql