BUG #3853: Autovacuum not working

From: "Christopher Brian L(dot) Jurado" <chris(dot)jurado(at)primesoft(dot)ph>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3853: Autovacuum not working
Date: 2008-01-07 05:44:02
Message-ID: 200801070544.m075i2uF001969@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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

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.


Browse pgsql-bugs by date

  From Date Subject
Next Message Bill Moran 2008-01-07 13:30:37 Re: BUG #3853: Autovacuum not working
Previous Message Tom Lane 2008-01-06 19:44:47 Re: BUG #3852: Could not create complex aggregate