Re: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Radu Ilie" <rilie(at)wsi(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5849: Stats Collector Frozen - Autovacuum Not Working Anymore
Date: 2011-01-26 17:21:52
Message-ID: 20057.1296062512@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joshua Farray 2011-01-26 18:05:40 BUG #5850: UPDATE statement fails when using aliases
Previous Message Jens Kapp 2011-01-26 16:17:51 NO DATA error message in Frontend when querying large datasets