On Mon, Dec 04, 2006 at 09:42:57AM -0800, Jeff Davis wrote: > > fsm_pages = 200,000 ??? Based this on some statistics about the number > > of pages freed from a vacuum on older server. Not sure if its fair > > to calculate this based on vacuum stats of 7.3.4 server? > > > > Might as well make it a higher number because you have a lot of RAM > anyway. It's better than running out of space in the FSM, because to > increase that setting you need to restart the daemon. Increasing this by > 1 only uses 6 bytes. That means you could set it to 10 times the number > you currently have, and it would still be insignificant. You can also run vacuumdb -av and look at the last few lines to see what it says you need. Or you can get that info out of contrib/pg_freespacemap. -- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
