Re: EXPLAIN ANALYZE on 8.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: EXPLAIN ANALYZE on 8.2
Дата
Msg-id 29450.1166141131@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: EXPLAIN ANALYZE on 8.2  ("Kelly Burkhart" <kelly.burkhart@gmail.com>)
Ответы Re: EXPLAIN ANALYZE on 8.2  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-performance
"Kelly Burkhart" <kelly.burkhart@gmail.com> writes:
> I hope this isn't a "crummy mainboard" but I can't seem to affect
> things by changing clock source (kernel 2.6.16 SLES10).  I tried
> kernel command option clock=XXX where XXX in
> (cyclone,hpet,pmtmr,tsc,pit), no option was significantly better than
> the default.

I believe that on machines where gettimeofday is really nice and fast,
it doesn't require entry to the kernel at all; there's some hack that
makes the clock readable from userspace.  (Obviously a switch to kernel
mode would set you back a lot of the cycles involved here.)  So it's not
so much the kernel that you need to teach as glibc.  How you do that is
beyond my expertise, but maybe that will help you google for the right
thing ...

            regards, tom lane

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: EXPLAIN ANALYZE on 8.2
Следующее
От: Ron
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations