Re: measure time intervals - Mailing list pgsql-general

From Vincent Dautremont
Subject Re: measure time intervals
Date
Msg-id CAA4Vp49Cn2VNYcpK22RgXDERVuuJYhLBjcePeAGXKVskVRqbvw@mail.gmail.com
Whole thread Raw
In response to Re: measure time intervals  (John R Pierce <pierce@hogranch.com>)
Responses Re: measure time intervals  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Thank you but my problem is precisely because I'm using Postrgresql on a windows computer and I cannot change that :-/

Vincent.

On Fri, Apr 6, 2012 at 1:40 PM, John R Pierce <pierce@hogranch.com> wrote:
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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Instangram is powered by PostgreSQL
Next
From: Merlin Moncure
Date:
Subject: Re: measure time intervals