pgadmin "Running VACUUM recommended"

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pgadmin "Running VACUUM recommended"
Date: 2011-06-15 20:01:36
Message-ID: 000b01cc2b97$0c39c370$24ad4a50$@devshock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message BRUSSER Michael 2011-06-15 20:18:27 Invalid byte sequence for encoding "UTF8": 0xedbebf
Previous Message Nigel Heron 2011-06-15 16:38:15 blks_read/blks_hit stats