| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Anibal David Acosta <aa(at)devshock(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pgadmin "Running VACUUM recommended" |
| Date: | 2011-06-15 20:43:02 |
| Message-ID: | 1308170582.1993.86.camel@laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2011-06-15 20:49:30 | You could be a PostgreSQL Patch Reviewer! |
| Previous Message | BRUSSER Michael | 2011-06-15 20:18:27 | Invalid byte sequence for encoding "UTF8": 0xedbebf |