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
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 |
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 |