Re: buildfarm animals and 'snapshot too old'

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: buildfarm animals and 'snapshot too old'
Дата
Msg-id 537CC73E.7060204@dunslane.net
обсуждение исходный текст
Ответ на Re: buildfarm animals and 'snapshot too old'  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 05/20/2014 09:42 AM, Tom Lane wrote:

>> Regarding clock skew, I think we can do better then what you suggest.
>> The web transaction code in the client adds its own timestamp just
>> before running the web transaction. It would be quite reasonable to
>> reject reports from machines with skewed clocks based on this value. I'm
>> not sure what a reasonable skew might be. Somewhere in the range of 5 to
>> 15 minutes seems reasonable.
> Rather than reject, why not take the result and adjust the claimed start
> timestamp by the difference between the web transaction timestamp and the
> buildfarm server's time?

Right now I have added some logging of clock skew to see what we're 
actually getting.

It won't be visible in the Web UI, but when I have some data I will post 
more info.

cheers

andrew




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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3
Следующее
От: Vik Fearing
Дата:
Сообщение: Re: Bison 3.0 updates