Re: Proposal: Commit timestamp

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Proposal: Commit timestamp
Дата
Msg-id 20070126143849.GP24675@kenobi.snowman.net
обсуждение исходный текст
Ответ на Re: Proposal: Commit timestamp  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: Proposal: Commit timestamp  (Andrew Dunstan <andrew@dunslane.net>)
Re: Proposal: Commit timestamp  (Jan Wieck <JanWieck@Yahoo.com>)
Список pgsql-hackers
* Jan Wieck (JanWieck@Yahoo.com) wrote:
> On 1/26/2007 2:37 AM, Naz Gassiep wrote:
> >I would be *very* concerned that system time is not a guaranteed
> >monotonic entity. Surely a counter or other internally managed mechanism
> >would be a better solution.
>
> Such a counter has only "local" relevance. How do you plan to compare
> the two separate counters on different machines to tell which
> transaction happened last?

I'd also suggest you look into Lamport timestamps...  Trusting the
system clock just isn't practical, even with NTP.  I've developed
(albeit relatively small) systems using Lamport timestamps and would be
happy to talk about it offlist.  I've probably got some code I could
share as well.
Thanks,
    Stephen

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: Proposal: Snapshot cloning
Следующее
От: Tom Lane
Дата:
Сообщение: Re: crash on 8.2 and cvshead - failed to add item to the