Postgres Pro
Downloads
Home   >   mailing lists

Re: Why is my stats collector so busy? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Why is my stats collector so busy?
Date
Msg-id 7975.1244653626@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why is my stats collector so busy?  (Laszlo Nagy <gandalf@shopzeus.com>)
List pgsql-performance
Tree view 
Laszlo Nagy <gandalf@shopzeus.com> writes:
> On a 8 processor system, my stats collector is always at 100% CPU.
> 8.3.5 on FreeBSD 7.0 amd64

Hmm.  How many tables in the installation?  Or perhaps more to the
point, how large is $PGDATA/global/pgstat.stat?  It might be that
it's just spending too much time dumping out that file.  There's
a fix for that planned for 8.4 ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: GiST index performance
Next
From: David Kerr
Date:
Subject: Re: Looking for installations with a large number of concurrent users