Re: [pgsql-hackers-win32] Help with tuning this query (with - Mailing list pgsql-performance

From Dave Page
Subject Re: [pgsql-hackers-win32] Help with tuning this query (with
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E472B994@ratbert.vale-housing.co.uk
Whole thread Raw
List pgsql-performance

> -----Original Message-----
> From: pgsql-hackers-win32-owner@postgresql.org
> [mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf
> Of Tom Lane
> Sent: 07 March 2005 22:57
> To: John A Meinel
> Cc: Dave Held; pgsql-performance@postgresql.org;
> pgsql-hackers-win32@postgresql.org
> Subject: Re: [pgsql-hackers-win32] [PERFORM] Help with tuning
> this query (with
>
> Which brings up a question: just what does QueryPerformanceCounter
> measure?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winui/w
inui/windowsuserinterface/windowing/timers/abouttimers.asp says:

If a high-resolution performance counter exists on the system, you can
use the QueryPerformanceFrequency function to express the frequency, in
counts per second. The value of the count is processor dependent. On
some processors, for example, the count might be the cycle rate of the
processor clock.

The QueryPerformanceCounter function retrieves the current value of the
high-resolution performance counter. By calling this function at the
beginning and end of a section of code, an application essentially uses
the counter as a high-resolution timer. For example, suppose that
QueryPerformanceFrequency indicates that the frequency of the
high-resolution performance counter is 50,000 counts per second. If the
application calls QueryPerformanceCounter immediately before and
immediately after the section of code to be timed, the counter values
might be 1500 counts and 3500 counts, respectively. These values would
indicate that .04 seconds (2000 counts) elapsed while the code executed.


Regards, Dave.

pgsql-performance by date:

Previous
From: jesse d
Date:
Subject: Help with slow running query
Next
From: "Michael Zoephel"
Date:
Subject: performance problems