> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
