Re: is pg_autovacuum so effective ? - Mailing list pgsql-performance

Gaetano Mendola <mendola@bigfoot.com> writes:
> I'm using ony pg_autovacuum. I expect that disk usage will reach
> a steady state but is not. PG engine: 7.4.5

One data point doesn't prove that you're not at a steady state.

> # vacuum full verbose messages;
> INFO:  vacuuming "public.messages"
> INFO:  "messages": found 77447 removable, 1606437 nonremovable row versions in 69504 pages
> ...
> INFO:  "messages": moved 55221 row versions, truncated 69504 to 63307 pages

10% overhead sounds fairly reasonable to me.  How does that compare to
the amount of updating you do on the table --- ie, do you turn over 10%
of the table in a day?

            regards, tom lane