Re: New features for pgbench

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: New features for pgbench
Дата
Msg-id 20070213083450.GB608@svr2.hagander.net
обсуждение исходный текст
Ответ на Re: New features for pgbench  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-patches
On Tue, Feb 13, 2007 at 01:08:04AM -0500, Greg Smith wrote:
> On Tue, 13 Feb 2007, Takayuki Tsunakawa wrote:
>
> >The Win32 APIs that pgbench is using for gettimeofday() (in
> >src/port/gettimeofday.c) is much lower in resolution than Linux.
>
> I wasn't aware of this issue, and it certainly makes the whole latency
> side of pgbench pretty useless on Win32.  There is code in
> src/include/executor/instrument.h that uses a higher resolution Windows
> timer API than gettimeofday() does (as you point out, that one is only
> resolves to one Windows tick, about 15ms).  If I can get a Windows build
> environment setup, I'll see if I can borrow that solution for pgbench.

As long as you only need to measure time *difference*, those are pretty
easy to use. Different from Unix, but easy. If you need to keep a
counter that contains actual time it can still be done, but it's a bit
more tricky (not really hard, though).

//Magnus

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New features for pgbench
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Have psql show current sequnce values - (Resubmission)