| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Rob Richardson <Rob(dot)Richardson(at)rad-con(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Autovacuum not started because of misconfiguration |
| Date: | 2010-11-03 20:03:31 |
| Message-ID: | AANLkTinG98=+fBwELWBG7dAMHnNZk6sz7-azNG254bMn@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 3, 2010 at 1:28 PM, Rob Richardson
<Rob(dot)Richardson(at)rad-con(dot)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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Richardson | 2010-11-03 20:09:57 | Re: Autovacuum not started because of misconfiguration |
| Previous Message | Tom Lane | 2010-11-03 20:01:23 | Re: Autovacuum not started because of misconfiguration |