Re: Maximum reasonable free space map

On Wed, Dec 17, 2008 at 2:29 AM, Phillip Berry
<pberry(at)stellaconcepts(dot)com> wrote:
>
> The data in nearly every table is constantly changing due to a high volume of new data constantly
> coming in, processing on the existing data and heavy reporting being done all at once all day and
> night.
>
> So I guess my question is, is there a point where you start to see diminishing returns or even
> negative returns by setting the fsm too high?

I personally didn't experience anything like that.
If the data is updated, but not deleted mostly - you should do
something to utilize HOT (if using 8.3).
Otherwise, you want FSM to be big enough - so that more and more
deleted records could get reused without need for so often vacuum.

--
GJ