Re: Why is my stats collector so busy?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Why is my stats collector so busy?
Date: 2009-06-10 17:07:06
Message-ID: 7975.1244653626@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Laszlo Nagy <gandalf(at)shopzeus(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Kerr 2009-06-10 19:57:42 Re: Looking for installations with a large number of concurrent users
Previous Message Tom Lane 2009-06-10 16:51:31 Re: GiST index performance