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

From Guillaume Lelarge
Subject Re: pgadmin "Running VACUUM recommended"
Date
Msg-id 1308170582.1993.86.camel@laptop
Whole thread Raw
In response to pgadmin "Running VACUUM recommended"  ("Anibal David Acosta" <aa@devshock.com>)
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


pgsql-general by date:

Previous
From: "Anibal David Acosta"
Date:
Subject: pgadmin "Running VACUUM recommended"
Next
From: Josh Berkus
Date:
Subject: You could be a PostgreSQL Patch Reviewer!