Thread: 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 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? > 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