Re: [pgsql-hackers-win32] explain analyze timings

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: [pgsql-hackers-win32] explain analyze timings
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE6C70E5@algol.sollentuna.se
обсуждение исходный текст
Ответы Re: [pgsql-hackers-win32] explain analyze timings  (Simon Riggs <simon@2ndquadrant.com>)
Re: [pgsql-hackers-win32] explain analyze timings  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
>> 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).

I also hacked commands/explain.c to get the total runtime of the query
correct.

//Magnus

Вложения

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

Предыдущее
От: Marko Kreen
Дата:
Сообщение: [patch 4/6] openssl.c: 3DES and AES support
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: [pgsql-hackers-win32] explain analyze timings