Steven Flatt wrote: > Sorry, I think there's a misunderstanding here. Our system is not doing > near that number of transactions per second. I meant that the duration of a > single DB-wide vacuum takes on the order of a couple of weeks. The time > between DB-wide vacuums is a little over a year, I believe.
I wonder if this is using some vacuum delay setting? If that's the case, I think you could manually run a database-wide vacuum with a zero vacuum delay setting, so that said vacuum takes less time to finish (say, once every 8 months). (8.2 pretty much solves this issue BTW, by not requiring database-wide vacuums). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
