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?
Cheers
Phil
On Wednesday 17 December 2008 13:02:21 Grzegorz Jaśkiewicz wrote:
> On Wed, Dec 17, 2008 at 12:55 AM, Phillip Berry
>
> <pberry@stellaconcepts.com> wrote:
> > I thought 185K was pretty high, is going to 700K+ reasonable? I've got
> > 16GB of ram and am running very high volume 100GB+ DBs.
>
> all depends on how often does the data change. I would go with
> whatever vacuum is suggesting on production :)
> in 8.4 you won't have to worry about it anymore anyway ;)