From: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
---|---|
To: | "Christopher Brian L(dot) Jurado" <chris(dot)jurado(at)primesoft(dot)ph> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3853: Autovacuum not working |
Date: | 2008-01-07 13:30:37 |
Message-ID: | 20080107083037.98a9ce00.wmoran@collaborativefusion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
In response to "Christopher Brian L. Jurado" <chris(dot)jurado(at)primesoft(dot)ph>:
>
> The following bug has been logged online:
>
> Bug reference: 3853
> Logged by: Christopher Brian L. Jurado
> Email address: chris(dot)jurado(at)primesoft(dot)ph
> PostgreSQL version: 8.1.2
> Operating system: Windows XP/2003
> Description: Autovacuum not working
> Details:
>
> I can see in the server logs that it has entries saying "autovacuum:
> processing database xxx". But it seems that pgAdmin still gives
> hints/suggestions that the tables need vacuuming. I don't know if this is a
> pgAdmin bug or not. But in my experience, pgAdmin seemed right and table
> statistics were not updated and query performance degrades as
> inserts/updates/deletes are done--because of outdated table statistics.
> Is this a bug? And if it is, was this fixed in 8.2? I can't find this in the
> release notes.
The autovacuum daemon has a lot of settings, it's possible that you simply
don't have it configured aggressively enough.
Please review the documentation and consider the fact that the default
settings are very conservative:
http://www.postgresql.org/docs/8.1/static/runtime-config-autovacuum.html
Additionally, you're missing 8 bug fixes in your version, I highly
recommend updating to 8.1.10 immediately.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2008-01-07 14:59:51 | Re: BUG #3852: Could not create complex aggregate |
Previous Message | Christopher Brian L. Jurado | 2008-01-07 05:44:02 | BUG #3853: Autovacuum not working |