sapiens=# vacuum verbose;
...
INFO: free space map: 1 relations, 39 pages stored; 48 total pages needed
DETAIL: Allocated FSM size: 1000 relations + 30000 pages = 237 kB shared memory.
1 relation and 48 pages seems too little, considering the defaults in the configuration.
The database is not too big, just 198 mb (contrib/dbsize tells me so), and I have 161 relations on pg_class (not counting the catalog).
I'm doing something wrong or 1 relation/48 pages would be just fine?
Thanks.
On Fri, 2003-12-05 at 13:17, Tom Lane wrote:
Ryan Mahoney <[EMAIL PROTECTED]> writes: > When interactively calculating the ideal value for max_fsm_pages by > summarizing the output of VACUUM VERBOSE, which statistic from vacuum am > I concerned with? 7.4 will tell you exactly how many FSM slots you need: foo=# vacuum verbose; ... INFO: free space map: 246 relations, 464 pages stored; 4160 total pages needed DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared memory. VACUUM In this example, the minimum FSM settings to not discard any data would be max_fsm_relations = 246, max_fsm_pages = 4160. Note that you need to have vacuumed all databases fairly recently for the totals to be really trustworthy. In previous versions you're kind of on your own :-( regards, tom lane ---------------------------(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
signature.asc
Description: This is a digitally signed message part