Ulrich Wisser <[EMAIL PROTECTED]> writes:
> max_fsm_relations = 10000
> max_fsm_pages = 100000
> The total database size on disk is ~6GB.
Most likely, you need larger max_fsm_pages. 6GB would work out to about
750K pages (of 8K each). With max_fsm_pages of 100K you are saying that
you don't expect more than one page in eight to have interesting amounts
of free space. That would be plenty for a low-turnover database ...
but ...
> Some tables get changed *very* frequently. A nightly "vacuum full
> analyze" frees about 250,000 rows on each of three tables.
... that does not sound like a low-turnover database.
> And yes I will change to 7.4 this week.
Once you are on 7.4, you can do a database-wide VACUUM VERBOSE to get
some stats about how loaded or overloaded the FSM is. Look at the last
few lines of the (very voluminous) output. If you have several active
databases, do a database-wide VACUUM in each of them and then look at
the VERBOSE result for the last. You want "total pages needed" to be
comfortably less than max_fsm_pages.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
