Re: Autovacuum not started because of misconfiguration - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Autovacuum not started because of misconfiguration
Date
Msg-id AANLkTinG98=+fBwELWBG7dAMHnNZk6sz7-azNG254bMn@mail.gmail.com
Whole thread Raw
In response to Autovacuum not started because of misconfiguration  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
List pgsql-general
On Wed, Nov 3, 2010 at 1:28 PM, Rob Richardson
<Rob.Richardson@rad-con.com> wrote:
> A customer found this in one PostgreSQL log file:
>
> EDTWARNING:  autovacuum not started because of misconfiguration
> This has only appeared once.  The database has been restarted since then
> (about eight days ago), and this message has not reappeared.  For now, we're
> not going to worry about it, but I remain curious.  What would have caused
> this, and where would I have looked to find the problem?

You don't mention the version of pgsql you're using, that might prove
helpful.  Basically on older pg versions when autovac first showed up
(7.4 or so) you had to turn the stats collector on and block level
stats for it to do its job.  It could be that got turned off for
troubleshooting or something a while back?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Autovacuum not started because of misconfiguration
Next
From: "Rob Richardson"
Date:
Subject: Re: Autovacuum not started because of misconfiguration