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

Reply via email to