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. 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
