> 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 

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 Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to