Thread

Re: partial vacuum

Tatsuo Ishii <t-ishii@sra.co.jp> — 2005-03-12T02:26:19Z

> Have you looked at the vacuum cost delay features present in 8.0?
> On the whole that seems like a better solution for reducing the impact
> of routine vacuuming than trying to manage partial vacuuming with an
> approach like this.

IMO vacuum cost delay seems not to be a solution. To keep long running
system's performance steady, we need to avoid table/index bloat(I
assume incoming trasanction rate is constant). Surely vacuum delay
reduces the impact, but the cost is taking longer time to salvage free
spaces, and FMS will run out due to incoming transactions, no?
--
Tatsuo Ishii