> > 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 <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part