pgadmin "Running VACUUM recommended" - Mailing list pgsql-general

From Anibal David Acosta
Subject pgadmin "Running VACUUM recommended"
Date
Msg-id 000b01cc2b97$0c39c370$24ad4a50$@devshock.com
Whole thread Raw
Responses Re: pgadmin "Running VACUUM recommended"
List pgsql-general

Hello, I have installed postgres 9.0 that is supposed has by default auto vacuum enabled

 

But sometimes when I click over a table in the pgadmin, this application recommend me to vacuum

The message is:

“The estimated rowcount on the table XXX deviates significantly from the actual rowcount. You should run VACUUM ANALYZE on this table.

 

Why this happened? The auto vacuum is not doing a good job?

 

Thanks

pgsql-general by date:

Previous
From: Nigel Heron
Date:
Subject: blks_read/blks_hit stats
Next
From: Guillaume Lelarge
Date:
Subject: Re: pgadmin "Running VACUUM recommended"