Re: tracking commit timestamps

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Noah Misch <noah(at)leadboat(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Steve Singer <steve(at)ssinger(dot)info>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, "Anssi K??ri?inen" <anssi(dot)kaariainen(at)thl(dot)fi>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Jaime Casanova <jaime(at)2ndquadrant(dot)com>
Subject: Re: tracking commit timestamps
Date: 2015-01-06 18:58:24
Message-ID: CA+TgmoYzep3knXnUcPNCDrj+0iG+yyfgBSfGAwqPCA_YSU5weA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

On Tue, Jan 6, 2015 at 2:58 AM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Petr Jelinek 2015-01-06 19:24:41 XLOG_PARAMETER_CHANGE handling of wal_log_hints
Previous Message Andres Freund 2015-01-06 18:56:12 Re: Re: [COMMITTERS] pgsql: Change how first WAL segment on new timeline after promotion is

Browse pgsql-www by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2015-01-10 15:06:24 Re: [DOCS] suggestion about SEO on www.postgresql.org/docs
Previous Message Bruce Momjian 2015-01-06 17:59:01 Re: [DOCS] suggestion about SEO on www.postgresql.org/docs