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.