Why is my stats collector so busy?

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Why is my stats collector so busy?
Date: 2009-06-05 09:58:40
Message-ID: 4A28EC50.6010609@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On a 8 processor system, my stats collector is always at 100% CPU.
Meanwhile disk I/O is very low. We have many databases, they are
accessed frequently. Sometimes there are big table updates, but in most
of the time only simple queries are ran against the databases, returning
a few records only. From the maximum possible 8.0 system load, the
average load is always above 1.1 and from this, 1.0 is the stats
collector and 0.1 is the remaining of the system. If I restart the
postgresql server, then the stats collector uses 0% CPU for about 10
minutes, then goes up to 100% again. Is there a way to tell why it is
working so much?

I asked this problem some months ago on a different mailing list. I was
asked to provide tracebacks of the stats collector, but due to a bug in
the FreeBSD ppid() function, I'm not able to trace the stats collector.

Thank you,

Laszlo

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2009-06-05 13:38:00 Re: Why is my stats collector so busy?
Previous Message Mark Mielke 2009-06-05 05:56:08 Re: Scalability in postgres