In response to "Christopher Brian L. Jurado" <[EMAIL PROTECTED]>:
> > The following bug has been logged online: > > Bug reference: 3853 > Logged by: Christopher Brian L. Jurado > Email address: [EMAIL PROTECTED] > 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/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
