Gaetano Mendola <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
