Tom Lane wrote:
Laszlo Nagy <gandalf@xxxxxxxxxxxx> 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.
My version is 8.3.3. Complied from FreeBSD ports. I just updated my
ports tree and that is the most up to date officially (sup)ported version.
The process is still running:
PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU
COMMAND
904 pgsql 1 105 0 22396K 5428K CPU1 1 856:13 99.02%
postgres
Do you have a whole lot of tables in this database?
One database has 140 tables, the other has 62. (There are two other
database instances but they are rarely used.)
(Or even more directly: how large is $PGDATA/global/pgstat.stat ?)
-rw------- 1 pgsql pgsql 54536 Nov 3 20:11 pgstat.stat
Thanks,
Laszlo
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
