Josh,
> O.k. maybe I am missing something.. but what can I do to make it so a
> vacuum full
> isn't required? Is this some 7.4 magic that I don't know about?
"magic" we've had since 7.2.0, Josh.
If your max_fsm_pages is set to higher than the level of data pages you
recycle between vacuums, and you don't run out of memory on the machine for
significant periods, then you need never do a vacuum_full.
The functionality in 7.4 extends this to indexes, eliminating the REINDEX in
most cases.
--
-Josh Berkus
Aglio Database Solutions
San Francisco