"Radu Ilie" <rilie@wsi.com> writes:
> PostgreSQL version: 8.4.4 32 bit
> We started noticing very poor performance one day ago. Turns out the
> autovacuum was no longer working.
Perhaps you ran into the cost_limit problem that was fixed in 8.4.6?
http://archives.postgresql.org/pgsql-committers/2010-11/msg00186.php
> Any idea why the stats collector was stuck?
I don't think you've offered any proof that the stats collector was
stuck. Waiting for a message would be its normal state.
regards, tom lane