pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Benjamin Minshall <minshall@intellicon.biz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: stats collector process high CPU utilization
Date: Thu, 01 Mar 2007 15:41:19 -0500
Message-ID: <45E73A6F.50800@intellicon.biz> (raw)
In-Reply-To: <16282.1172779976@sss.pgh.pa.us>
References: <45CB5D06.7090004@intellicon.biz>
	<7994.1170960391@sss.pgh.pa.us>
	<45CB9330.3000603@intellicon.biz>
	<19935.1170969862@sss.pgh.pa.us>
	<45CB9C4D.30902@intellicon.biz>
	<20601.1170972476@sss.pgh.pa.us>
	<45CBA443.9090101@intellicon.biz>
	<7959.1170986672@sss.pgh.pa.us>
	<62089.75.14.32.120.1170994418.squirrel@intellicon.biz>
	<14668.1170995218@sss.pgh.pa.us>
	<20070209142459.GB4253@alvh.no-ip.org>
	<24717.1171033699@sss.pgh.pa.us>
	<29832.1171036557@sss.pgh.pa.us>
	<45CCA0DB.2010903@intellicon.biz>
	<1116.1171038786@sss.pgh.pa.us>
	<45CCBF13.2000707@intellicon.biz>
	<16282.1172779976@sss.pgh.pa.us>

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

Attachments:

  smime.p7s (application/x-pkcs7-signature, 5.1K) download

view thread (27+ messages)  latest in thread

Message-ID: <45E73A6F.50800@intellicon.biz>
Permalink:  ../45E73A6F.50800@intellicon.biz/
Also on:    postgresql.org/message-id/45E73A6F.50800@intellicon.biz

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: minshall@intellicon.biz, tgl@sss.pgh.pa.us
  Subject: Re: stats collector process high CPU utilization
  In-Reply-To: <45E73A6F.50800@intellicon.biz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox