Re: [GENERAL] measure time intervals

2012-04-10 Thread John R Pierce
On 04/10/12 6:48 AM, Raymond O'Donnell wrote: Windows can adjust the time using NTP also, though I don't know how abruptly or otherwise it does it. Under your date & time settings there should be an "Internet time" tab. the built in Windows Internet Time does a time step every 24 hours(or so

Re: [GENERAL] measure time intervals

2012-04-10 Thread Vincent Dautremont
Thank you. I was searching if there was such feature included in postgresql. I'll find another way around to achieve what I want with this. As I have to use windows NTP colient and not a 3rd party client I'll go check windows NTP client configuration, see if I can make it act as the Unix one does.

Re: [GENERAL] measure time intervals

2012-04-10 Thread Raymond O'Donnell
On 10/04/2012 14:39, Vincent Dautremont wrote: > Thank you but my problem is precisely because I'm using Postrgresql on a > windows computer and I cannot change that :-/ Windows can adjust the time using NTP also, though I don't know how abruptly or otherwise it does it. Under your date & time set

Re: [GENERAL] measure time intervals

2012-04-10 Thread Merlin Moncure
On Thu, Apr 5, 2012 at 9:00 AM, Vincent Dautremont wrote: > Hi, > I'm wondering ig it is possible to measure elapsed time between 2 particular > queries in PostgreSQL. > > what I need is the equivalent of @@TIMETICKS in Transac-SQL > or CLOCK_MONOTONIC  in Unix > or GetTickCount in Windows > > The

Re: [GENERAL] measure time intervals

2012-04-10 Thread Vincent Dautremont
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 wrote: > On 04/05/12 7:00 AM, Vincent Dautremont wrote: > >> These are not affected by system time changes, so time inter

Re: [GENERAL] measure time intervals

2012-04-06 Thread John R Pierce
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

[GENERAL] measure time intervals

2012-04-06 Thread Vincent Dautremont
Hi, I'm wondering ig it is possible to measure elapsed time between 2 particular queries in PostgreSQL. what I need is the equivalent of @@TIMETICKS in Transac-SQL or CLOCK_MONOTONIC in Unix or GetTickCount in Windows These are not affected by system time changes, so time interval can be calcula