Laszlo Nagy <gandalf@shopzeus.com> writes:
> The processi is using 100% CPU for 52 hours! Here it is:
> %ps axl | grep 677
> 70 677 666 757 107 0 22396 5460 select Rs ?? 3144:50.88
> postgres: stats collector process (postgres)
Huh, that's weird. We've fixed some bugs in the past that led the stats
collector to consume excessive CPU --- but that was all pre-8.3.
Do you have a whole lot of tables in this database? (Or even more
directly: how large is $PGDATA/global/pgstat.stat ?)
regards, tom lane