> > I've increased the value to 40000 since we have much busier days, and I'll
> > se what happens.
>
> Hang on - so when vacuum runs it knows exactly how many pages it cleaned up
> but if the fsm value is low, it doesn't help? Why don't we just
> automaticlaly set the FSM value to the max that vacuum has to clean up? Why
> don't we introduce: max_fsm_pages = auto or something?
I assume it uses shared memory, so I doubt it's very easy to increase on
the fly -- without having to reduce something else anyway.
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc