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 по дате отправления