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

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: [pgsql-hackers-win32] Help with tuning this query (with
Дата
Msg-id 20050308013750.GA29367@uio.no
обсуждение исходный текст
Ответ на Re: [pgsql-hackers-win32] Help with tuning this query (with  ("Dave Held" <dave.held@arrayservicesgrp.com>)
Ответы Re: [pgsql-hackers-win32] Help with tuning this query (with  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [pgsql-hackers-win32] Help with tuning this query (with  (PFC <lists@boutiquenumerique.com>)
Список pgsql-performance
On Mon, Mar 07, 2005 at 06:11:34PM -0600, Dave Held wrote:
>> In which case using it would be a mistake. Since rtdsc doesn't
>> work across processors.
> It doesn't always use RDTSC.  I can't find anything authoritative on
> when it does.  I would assume that it would use RDTSC when available
> and something else otherwise.

RDTSC is a bad source of information for this kind of thing, as the CPU
frequency might vary. Check your QueryPerformanceFrequency() -- most likely
it will not match your clock speed. I haven't tested on a lot of machines,
but I've never seen QueryPerformanceFrequency() ever match the clock speed,
which it most probably would if it was using RDTSC. (I've been told it uses
some other kind of timer available on most motherboards, but I don't know the
details.)

/* Steinar */
--
Homepage: http://www.sesse.net/

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Dave Held"
Дата:
Сообщение: Re: [pgsql-hackers-win32] Help with tuning this query (with
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [pgsql-hackers-win32] Help with tuning this query (with