Tom,
> Not at all. What it says is that you expect 100% of the pages to have
> useful amounts of free space, which is a *much* weaker criterion.
Hmmm. Good point.
This seems to be another instance where my rule-of-thumb was based on false
logic but nevertheless arrived at correct numbers. I've seldom, if ever, set
FSM_pages above 50% of the pages in the active database ... and never run
out.
Hmmmm .... actually, it seems like, if you are vacuuming regularly, you only
*do* need to track pages that have been touched by DELETE or UPDATE. Other
pages would have already been vacuumed and not have any useful free space
left. Yes?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco