Postgres Pro
Downloads
Home   >   mailing lists

Re: measure time intervals - Mailing list pgsql-general

From John R Pierce
Subject Re: measure time intervals
Date
Msg-id 4F7F2A82.601@hogranch.com
Whole thread Raw
In response to measure time intervals  (Vincent Dautremont <vincent@searidgetech.com>)
Responses Re: measure time intervals  (Vincent Dautremont <vincent@searidgetech.com>)
List pgsql-general
Tree view 
On 04/05/12 7:00 AM, Vincent Dautremont wrote:
> These are not affected by system time changes, so time interval can be
> calculated even if the system time is changed by NTP or the user.
> That's why I can't use any function based on system time.

properly configured Unix NTP doesn't step-change the clock, it very
gently slows it down or speeds it up until it is accurate and maintains
stability.  and only root can change the clock on a Unix system, so this
really shouldn't be a concern.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-general by date:

Previous
From: "EXT-Rothermel, Peter M"
Date:
Subject: Re: Using DEFAULT as a parameter value with PQexecPrepare()
Next
From: John R Pierce
Date:
Subject: Re: EDB - oracle compatibility (Nested Tables)