Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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



In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-01-31 17:53:17
Subject: Re: BUG #5857: pg_restore --clean dropping type too soon
Previous:From: Stuart BishopDate: 2011-01-31 13:44:59
Subject: BUG #5857: pg_restore --clean dropping type too soon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group