On Friday 23 April 2004 14:57, Ron St-Pierre wrote: Does this apply to 7.3.4 also? > Actually, since he's running 7.4, there's an even better way. Do a > "VACUUM VERBOSE" (full-database vacuum --- doesn't matter whether you > ANALYZE or not). At the end of the very voluminous output, you'll see > something like > > > INFO: free space map: 240 relations, 490 pages stored; 4080 total pages > needed DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB > shared memory. > > > Here, I would need max_fsm_relations = 240 and max_fsm_pages = 4080 to > exactly cover the present freespace needs of my system. I concur with > the suggestion to bump that up a good deal, of course, but that gives > you a real number to start from. > > > The DETAIL part of the message shows my current settings (which are the > defaults) and what the FSM is costing me in shared memory space. > > Good luck > Ron > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html