Postgres Pro
Downloads
Home   >   mailing lists

8.1: autovacuum not doing its job? - Mailing list pgsql-novice

From
Subject 8.1: autovacuum not doing its job?
Date
Msg-id 00a701c5ea49$0d8e50f0$0201a8c0@iwing
Whole thread Raw
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Martin Foster
Date:
Subject: Re: Difficulties Storing Case Sensitive DDL Definitions
Next
From: Michael Glaesemann
Date:
Subject: Re: createdb Question