This week is looking busy for me but hopefully I'll be able to play around
with various vacuuming frequencies for this table ...
Thanks for all of your help; I'll report on my progress
-Dave
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Wednesday, July 13, 2005 5:40 PM
>
> 1. VACUUM more often than once per day.
>
> 2. Live with a steady-state index size that's about 5x the minimum.
>
> I'd recommend taking a hard look at choice #1 --- you could experiment
> with using the "vacuum cost delay" settings to tamp down VACUUM's I/O
> demand to the point where it doesn't kill interactive performance, and
> then run it maybe every hour or two on the table(s) where you
> have this
> problem.
>