Skip site navigation (1) Skip section navigation (2)

Re: explain analyze timings

From: John A Meinel <john(at)arbash-meinel(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: explain analyze timings
Date: 2005-03-20 16:01:39
Message-ID: 423D9E63.2060008@arbash-meinel.com (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-patches
Simon Riggs wrote:

>On Sun, 2005-03-20 at 14:42 +0100, Magnus Hagander wrote:
>  
>
>>>>There is. I beleive QueryPerformanceCounter has sub-mirosecond
>>>>resolution.
>>>>        
>>>>
>>>>Can we just replace gettimeofday() with a version that's basically:
>>>>        
>>>>
>>>No, because it's also used for actual time-of-day calls.  It'd be
>>>necessary to hack executor/instrument.c in particular.
>>>      
>>>
>>Here's a patch that does just this.
>>
>>On my system, the counter resolution is 3192090000 ticks per second
>>(Intel Xeon CPU). On a AMD Athlon XP system, it's 3579545 ticks per
>>second (a lot less, but still way way way better than gettimeofday has
>>on win32).
>>    
>>
>
>Is this just a Win32 hack?
>
>I've been looking for a sub-millisecond counter on other OS for a while
>now...anybody know of any port specific counters elsewhere?
>
>Thanks,
>
>  
>
gettimeofday has microsecond resolution. And on most platforms you 
actually do get good resolution from it.
QueryPerformanceCounter is win32 only, and it has variable resolution, 
as determined by QueryPerformanceFrequency. (obviously as above the Xeon 
claims 3B/s while Athlon is only 3.5M/s)
But that is just the finest resolution they can show, you still need to 
test to see what the resolution they can give you.
On my dual Xeon I get Freq=2399360000 =2.4B/s In testing, the call 
overhead seems to be about .35us, so the resolution is just < 1us.

>Best Regards, Simon Riggs
>  
>
John
=:->

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2005-03-20 17:42:58
Subject: Re: explain analyze timings
Previous:From: Simon RiggsDate: 2005-03-20 15:31:48
Subject: Re: explain analyze timings

pgsql-hackers-win32 by date

Next:From: Magnus HaganderDate: 2005-03-20 16:02:35
Subject: Re: Half filled xlogs
Previous:From: Simon RiggsDate: 2005-03-20 15:37:28
Subject: Half filled xlogs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group