From: | "Ilie, Radu" <rilie(at)wsi(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore |
Date: | 2011-01-31 15:19:21 |
Message-ID: | 0AA96E08D709BC4A9FAB7261A1C7AF080786A9@EXCHANGE.ad.wsicorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Thank you, that was it. We upgraded to 8.4.6 and the problem went away.
Radu
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, January 26, 2011 12:22 PM
To: Ilie, Radu
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #5849: Stats Collector Frozen - Autovacuum Not
Working Anymore
"Radu Ilie" <rilie(at)wsi(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-01-31 17:53:17 | Re: BUG #5857: pg_restore --clean dropping type too soon |
Previous Message | Stuart Bishop | 2011-01-31 13:44:59 | BUG #5857: pg_restore --clean dropping type too soon |