Re: stats collector process high CPU utilization

From: Benjamin Minshall <minshall(at)intellicon(dot)biz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: stats collector process high CPU utilization
Date: 2007-03-01 20:41:19
Message-ID: 45E73A6F.50800@intellicon.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Deucher 2007-03-01 20:44:03 strange performance regression between 7.4 and 8.1
Previous Message Alex Deucher 2007-03-01 20:40:28 strange performance regression between 7.4 and 8.1