From:
Peter Eisentraut <peter_e(at)gmx(dot)net>
To:
pgsql-hackers(at)postgresql(dot)org
Cc:
Jan Wieck <JanWieck(at)yahoo(dot)com>,
Bruce Momjian <bruce(at)momjian(dot)us>,
Theo Schlossnagle <jesus(at)omniti(dot)com>,
Jim Nasby <decibel(at)decibel(dot)org>
Subject:
Re: Proposal: Commit timestamp
Date:
2007-02-04 08:16:42
Message-ID:
200702040916.44380.peter_e@gmx.net (view raw or flat )
Thread:
2007-01-25 23:16:05 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-25 23:47:39 from Neil Conway <neilc(at)samurai(dot)com>
2007-01-26 00:31:20 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-26 00:41:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-26 00:49:46 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-25 23:49:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-01-26 00:42:24 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-26 04:41:30 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-01-26 05:41:55 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-26 10:54:25 from Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
2007-01-26 10:36:11 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-01-26 01:42:32 from Richard Troy <rtroy(at)ScienceTools(dot)com>
2007-01-26 02:01:29 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-26 07:37:13 from Naz Gassiep <naz(at)mira(dot)net>
2007-01-26 13:11:23 from Theo Schlossnagle <jesus(at)omniti(dot)com>
2007-01-26 13:21:40 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-26 14:38:49 from Stephen Frost <sfrost(at)snowman(dot)net>
2007-01-26 15:10:56 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-01-26 15:53:47 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-27 12:26:14 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-01-27 14:14:02 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-01-26 13:26:21 from "Simon Riggs" <simon(at)2ndquadrant(dot)com>
2007-01-26 13:44:58 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-02 04:23:00 from Jim Nasby <decibel(at)decibel(dot)org>
2007-02-03 20:52:50 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-03 21:05:20 from Theo Schlossnagle <jesus(at)omniti(dot)com>
2007-02-03 21:38:51 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-03 21:58:27 from Theo Schlossnagle <jesus(at)omniti(dot)com>
2007-02-03 22:09:00 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-03 22:19:15 from Theo Schlossnagle <jesus(at)omniti(dot)com>
2007-02-03 22:20:45 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-04 05:04:54 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-04 08:16:42 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2007-02-04 15:06:27 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-04 15:53:32 from Theo Schlossnagle <jesus(at)omniti(dot)com>
2007-02-04 16:34:00 from Gregory Stark <stark(at)enterprisedb(dot)com>
2007-02-04 18:36:03 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-04 19:04:27 from Theo Schlossnagle <jesus(at)omniti(dot)com>
2007-02-06 07:36:31 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-02-06 09:25:29 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-06 16:44:33 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-02-07 00:29:11 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-07 07:37:59 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-02-07 16:54:28 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-07 17:54:56 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-02-07 19:15:31 from Richard Troy <rtroy(at)ScienceTools(dot)com>
2007-02-08 03:13:22 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-08 03:35:50 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-08 04:01:31 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-08 04:12:28 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-08 19:14:18 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-08 19:38:36 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-08 19:59:37 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2007-02-08 20:32:41 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-09 00:28:28 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-09 00:36:20 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-09 03:44:02 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-09 03:49:52 from Bruce Momjian <bruce(at)momjian(dot)us>
2007-02-09 04:41:11 from Richard Troy <rtroy(at)ScienceTools(dot)com>
2007-02-09 05:38:37 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-09 19:27:39 from Richard Troy <rtroy(at)ScienceTools(dot)com>
2007-02-09 19:23:03 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-02-09 20:20:55 from Richard Troy <rtroy(at)ScienceTools(dot)com>
2007-02-09 20:25:27 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-02-09 20:37:02 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-02-09 22:49:07 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-09 20:01:23 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-09 20:25:06 from Richard Troy <rtroy(at)ScienceTools(dot)com>
2007-02-09 06:24:08 from Kris Jurka <books(at)ejurka(dot)com>
2007-02-09 07:17:19 from "J(dot) Andrew Rogers" <jrogers(at)neopolitan(dot)com>
2007-02-09 19:19:41 from "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com>
2007-02-09 20:16:42 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-08 01:13:10 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-08 02:27:52 from Markus Schiltknecht <markus(at)bluegap(dot)ch>
2007-02-08 03:35:02 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-08 09:35:47 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-05 22:38:17 from Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
2007-02-05 11:20:25 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-07 03:31:55 from Jim Nasby <decibel(at)decibel(dot)org>
2007-02-07 12:13:36 from José Orlando Pereira <jop(at)lsd(dot)di(dot)uminho(dot)pt>
2007-02-09 06:04:13 from Jan Wieck <JanWieck(at)Yahoo(dot)com>
2007-02-21 16:26:32 from José Orlando Pereira <jop(at)lsd(dot)di(dot)uminho(dot)pt>
Lists:
pgsql-hackers
Jan Wieck wrote:
> This is all that is needed for last update wins resolution. And as
> said before, the only reason the clock is involved in this is so that
> nodes can continue autonomously when they lose connection without
> conflict resolution going crazy later on, which it would do if they
> were simple counters. It doesn't require microsecond synchronized
> clocks and the system clock isn't just used as a Lamport timestamp.
Earlier you said that "one assumption is that all servers in the
multimaster cluster are ntp synchronized", which already rung the alarm
bells in me. Now that I read this you appear to require
synchronization not on the microsecond level but on some level. I
think that would be pretty hard to manage for an administrator, seeing
that NTP typically cannot provide such guarantees.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
In response to
Responses
pgsql-hackers by date
Next :From: Simon RiggsDate: 2007-02-04 09:25:18Subject : Re: Remove log segment and log_id fields from pg_controldataPrevious :From : Jan WieckDate : 2007-02-04 06:01:44Subject : Re: Referential Integrity and SHARE locks
