I ran into the same problem with VACUUM on my Linux box. If you are running
Linux, take a look at "elvtune" or read this post:


Regards, Stephen

"Rob Nagler" <[EMAIL PROTECTED]> wrote in message
> Manfred Koizar writes:
> > ISTM you are VACCUMing too aggressively.  You are reclaiming less than
> > 1% and 0.005%, respectively, of tuples.  I would increase FSM settings
> > to ca. 1000 fsm_relations, 100000 fsm_pages and VACUUM *less* often,
> > say every two hours or so.
> I did this.  We'll see how it goes.
> > ... or configure autovacuum to VACUUM a table when it has 10% dead
> > tuples.
> This solution doesn't really fix the fact that VACUUM consumes the
> disk while it is running.  I want to avoid the erratic performance on
> my web server when VACUUM is running.
> mfg,
> Rob
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to [EMAIL PROTECTED] so that your
>       message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to