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
