Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed

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.