Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector? - Mailing list pgsql-general

hubert depesz lubaczewski <depesz@depesz.com> writes:
> friend asked me to setup replication on their machines, and i noticed
> that one of cpus (2 quad xeons) is used to 100%:
> pgsql  58241 99.0  0.2 22456  7432  ??  Rs   Thu10AM 1530:35.93 postgres: stats collector process    (postgres)

Hmm, we had some problems with the stats collector going nuts a couple
of versions ago; maybe you've found another way to trigger that.
Anything unusual about this DB (lots of tables, for instance)?
Can you try strace and/or gdb to figure out what the collector is doing?

            regards, tom lane