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

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: [pgsql-hackers-win32] Help with tuning this query (with
Дата
Msg-id 874qfnbac5.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: [pgsql-hackers-win32] Help with tuning this query (with  (John A Meinel <john@arbash-meinel.com>)
Список pgsql-performance
John A Meinel <john@arbash-meinel.com> writes:

> Then we would only be wrong for 256 gettimeofday calls. I agree it isn't
> great, though. And probably better to just abstract (possibly just with
> #ifdef) the calls for accurate timing, from the calls that actually need
> the real time.

What would be really neato would be to use the rtdsc (sp?) or equivalent
assembly instruction where available. Most processors provide such a thing and
it would give much lower overhead and much more accurate answers.

The main problem I see with this would be on multi-processor machines.
(QueryPerformanceCounter does work properly on multi-processor machines,
right?)

--
greg

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Help trying to tune query that executes 40x slower than in SqlServer
Следующее
От: "Dave Held"
Дата:
Сообщение: Re: [pgsql-hackers-win32] Help with tuning this query (with