| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Noah Misch <noah(at)leadboat(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(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 07:58:14 |
| Message-ID: | CAB7nPqTF2b00kFZghaF=OFfnzY4G-JrcqnmyGj9Hm4cvXq6keQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-www |
On Fri, Dec 19, 2014 at 3:53 PM, Noah Misch <noah(at)leadboat(dot)com> wrote:
> localhost template1=# select clock_timestamp(), pg_sleep(.1 * (n % 2)) from generate_series(0,7) t(n);
> clock_timestamp | pg_sleep
> -------------------------------+----------
> 2014-12-18 08:34:34.522126+00 |
> 2014-12-18 08:34:34.522126+00 |
> 2014-12-18 08:34:34.631508+00 |
> 2014-12-18 08:34:34.631508+00 |
> 2014-12-18 08:34:34.74089+00 |
> 2014-12-18 08:34:34.74089+00 |
> 2014-12-18 08:34:34.850272+00 |
> 2014-12-18 08:34:34.850272+00 |
> (8 rows)
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.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Atri Sharma | 2015-01-06 08:03:49 | Re: Patch to add functionality to specify ORDER BY in CREATE FUNCTION for SRFs |
| Previous Message | Amit Langote | 2015-01-06 07:52:46 | Re: Patch to add functionality to specify ORDER BY in CREATE FUNCTION for SRFs |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Petr Jelinek | 2015-01-06 12:12:09 | Re: tracking commit timestamps |
| Previous Message | Petr Jelinek | 2015-01-05 16:50:04 | Re: tracking commit timestamps |