Thank you, that was it. We upgraded to 8.4.6 and the problem went away. Radu
-----Original Message----- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, January 26, 2011 12:22 PM To: Ilie, Radu Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore "Radu Ilie" <ri...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
