Home > Archive > PostgreSQL Newbies > November 2005 > 8.1: autovacuum not doing its job?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author 8.1: autovacuum not doing its job?
me@alternize.com

2005-11-15, 8:24 pm

hi list

on a 8.1 database, pgAdmin III warns me on several tables:

Running VACUUM recommended
The estimated rowcount on the table "forum.notifications" deviates significantly from the actual rowcount. You should run VACUUM ANALYZE on this table.

shouldn't autovacuum take care of this on a regular basis? how do i need to tweak the autovacuum settings to have proper vacuumed tables?

thanks for helping,
thomas
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com