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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
