Skip site navigation (1) Skip section navigation (2)

8.1: autovacuum not doing its job?

From: <me(at)alternize(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: 8.1: autovacuum not doing its job?
Date: 2005-11-16 00:59:52
Message-ID: 00a701c5ea49$0d8e50f0$0201a8c0@iwing (view raw or flat)
Thread:
Lists: pgsql-novice
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

Next:From: Michael GlaesemannDate: 2005-11-16 01:33:17
Subject: Re: createdb Question
Previous:From: operationsengineer1Date: 2005-11-15 23:45:56
Subject: createdb Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group