Re: tracking commit timestamps

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: tracking commit timestamps
Дата
Msg-id CA+TgmoYzep3knXnUcPNCDrj+0iG+yyfgBSfGAwqPCA_YSU5weA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: tracking commit timestamps  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On Tue, Jan 6, 2015 at 2:58 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> So, we would need additional information other than the node ID *and*
> the timestamp to ensure proper transaction commit ordering on Windows.
> That's not cool and makes this feature very limited on this platform.

You can't use the timestamp alone for commit ordering on any platform.
Eventually, two transactions will manage to commit in a single clock
tick, no matter how short that is.

Now, if we'd included the LSN in there...

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Change how first WAL segment on new timeline after promotion is
Следующее
От: Petr Jelinek
Дата:
Сообщение: XLOG_PARAMETER_CHANGE handling of wal_log_hints