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

From Tom Lane
Subject Re: [pgsql-hackers-win32] Help with tuning this query (with
Date
Msg-id 1971.1110247358@sss.pgh.pa.us
Whole thread Raw
In response to Re: [pgsql-hackers-win32] Help with tuning this query (with  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Responses Re: [pgsql-hackers-win32] Help with tuning this query (with  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
"Steinar H. Gunderson" <sgunderson@bigfoot.com> writes:
> RDTSC is a bad source of information for this kind of thing, as the CPU
> frequency might vary.

One thought that was bothering me was that if the CPU goes idle while
waiting for disk I/O, its clock might stop or slow down dramatically.
If we believed such a counter for EXPLAIN, we'd severely understate
the cost of disk I/O.

I dunno if that is the case on any Windows hardware or not, but none
of this thread is making me feel confident that we know what
QueryPerformanceCounter does measure.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: [pgsql-hackers-win32] Help with tuning this query (with
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: [pgsql-hackers-win32] Help with tuning this query (with