Re: stats collector process high CPU utilization

Поиск
Список
Период
Сортировка
Искать
От
Benjamin Minshall
Тема
Re: stats collector process high CPU utilization
Дата
Msg-id
45E73A6F.50800@intellicon.biz
Ответ на
Список
Дерево обсуждения
stats collector process high CPU utilization Benjamin Minshall <minshall@intellicon.biz>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Benjamin Minshall <minshall@intellicon.biz>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Benjamin Minshall <minshall@intellicon.biz>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Benjamin Minshall <minshall@intellicon.biz>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Benjamin Minshall <minshall@intellicon.biz>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization minshall@intellicon.biz
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Alvaro Herrera <alvherre@commandprompt.com>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Benjamin Minshall <minshall@intellicon.biz>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Benjamin Minshall <minshall@intellicon.biz>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Bruce Momjian <bruce@momjian.us>
Re: stats collector process high CPU utilization "Joshua D. Drake" <jd@commandprompt.com>
Re: stats collector process high CPU utilization Benjamin Minshall <minshall@intellicon.biz>
Re: stats collector process high CPU utilization "Merlin Moncure" <mmoncure@gmail.com>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization "Merlin Moncure" <mmoncure@gmail.com>
Re: stats collector process high CPU utilization Tom Lane <tgl@sss.pgh.pa.us>
Re: stats collector process high CPU utilization Magnus Hagander <magnus@hagander.net>
Tom Lane 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.
> 
> If you want to patch this before 8.2.4, try this...
> 

Thanks for the follow-up on this issue, Tom.  I was able to link the 
original huge stats file problem to some long(ish) running transactions 
which blocked VACUUM, but this patch will really help.  Thanks.

-Ben
В списке pgsql-performance по дате отправления
От: Tom Lane
Дата:
От: Alex Deucher
Дата:
FAQ