Re: Proposal for CSN based snapshots

Поиск
Список
Период
Сортировка
От Ants Aasma
Тема Re: Proposal for CSN based snapshots
Дата
Msg-id CA+CSw_utvZdR1QZ318xcDAK5-S0ghAdzLJH0kGM5oX1Np7KVaw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposal for CSN based snapshots  (Greg Stark <stark@mit.edu>)
Список pgsql-hackers
On Fri, Jun 7, 2013 at 3:47 PM, Greg Stark <stark@mit.edu> wrote:
> On Thu, Jun 6, 2013 at 11:42 PM, Ants Aasma <ants@cybertec.at> wrote:
>> To refresh your memory the basic idea is to change visibility
>> determination to be based on a commit sequence number (CSN for short)
>> - a 8 byte number incremented on every commit representing the total
>> ordering of commits
>
> I think we would just use the LSN of the commit record which is
> effectively the same but doesn't require a new counter.
> I don't think this changes anything though.

I briefly touched on that point in the Hot Standby section. This has
some consequences for locking in CommitTransaction, but otherwise LSN
is as good as any other monotonically increasing value.

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 по дате отправления:

Предыдущее
От: Ants Aasma
Дата:
Сообщение: Re: Proposal for CSN based snapshots
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: system catalog pg_rewrite column ev_attr document description problem