Re: stats collector process high CPU utilization

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: stats collector process high CPU utilization
Дата
Msg-id 17817.1172789069@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: stats collector process high CPU utilization  ("Merlin Moncure" <mmoncure@gmail.com>)
Ответы Re: stats collector process high CPU utilization  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-performance
"Merlin Moncure" <mmoncure@gmail.com> writes:
> On 3/1/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> A further report led us to realize that 8.2.x in fact has a nasty bug
>> here: the stats collector is supposed to dump its stats to a file at
>> most every 500 milliseconds, but the code was actually waiting only
>> 500 microseconds :-(.  The larger the stats file, the more obvious
>> this problem gets.

> I think this explains the trigger that was blowing up my FC4 box.

I dug in the archives a bit and couldn't find the report you're
referring to?

            regards, tom lane

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

Предыдущее
От: "Craig A. James"
Дата:
Сообщение: Re: Identical Queries
Следующее
От: "Alex Deucher"
Дата:
Сообщение: Re: strange performance regression between 7.4 and 8.1