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

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