Re: Finding bottleneck

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Finding bottleneck
Дата
Msg-id 17939.1124460192@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Finding bottleneck  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Список pgsql-performance
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Relative to 8.0, I am seeing a dramatic, almost miraculous reduction in
> CPU load times in 8.1devel.  This is for ISAM style access patterns over
> the parse/bind interface.  (IOW one record at a time, 90% read, 10%
> write).

> Relative to commercial dedicated ISAM storage engines, pg holds up very
> well except in cpu load, but 8.1 is a huge step towards addressing that.

Cool --- we've done a fair amount of work on squeezing out internal
inefficiencies during this devel cycle, but it's always hard to predict
just how much anyone will notice in the real world.

Care to do some oprofile or gprof profiles to see where it's still bad?

            regards, tom lane

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

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: sustained update load of 1-2k/sec
Следующее
От: Tom Lane
Дата:
Сообщение: Re: sustained update load of 1-2k/sec