pgadmin "Running VACUUM recommended"
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
On Wed, 2011-06-15 at 16:01 -0400, Anibal David Acosta wrote:
Hello, I have installed postgres 9.0 that is supposed has by default
auto vacuum enabledBut sometimes when I click over a table in the pgadmin, this
application recommend me to vacuumThe 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?
Nope. pgAdmin detects that with a really simple algorithm. Not sure it's
still a good one. There are better chances pgAdmin is wrong than
autovacuum.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com