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@xxxxxxxxxxxxx] > 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. > ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
