Re: gprof SELECT COUNT(*) results

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: gprof SELECT COUNT(*) results
Дата
Msg-id Pine.LNX.4.58.0511242249540.13062@eon.cs
обсуждение исходный текст
Ответ на Re: gprof SELECT COUNT(*) results  (Greg Stark <gsstark@mit.edu>)
Ответы Re: gprof SELECT COUNT(*) results  (Qingqing Zhou <zhouqq@cs.toronto.edu>)
Список pgsql-hackers

On Thu, 24 Nov 2005, Greg Stark wrote:

>
>
> You executed LWLock 2.6 million times in just under 300ms. If my math is right
> that's about 115 nanoseconds per lock or about 300 cycles on a 2.6Ghz
> processor.
>
> That sounds like a lot but it's about the right order of magnitude. Was this
> on a multiprocessor machine? In which case a big part of that time is probably
> spent synchronizing between the processors.
>

Your math is right iff my math is right :-) It is a 2.4G desktop computer.
I may need to write some separate tests to see if this is what we should
pay for bus lock instruction.

Regards,
Qingqing


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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: gprof SELECT COUNT(*) results
Следующее
От: Tom Lane
Дата:
Сообщение: Re: gprof SELECT COUNT(*) results