On Dienstag 07 Juli 2009 Scott Whitney wrote: > max_fsm_pages = 1500000 # min max_fsm_relations*16, 6 > bytes each > max_fsm_relations = 70000 # min 100, ~70 bytes each > > It's quite possible that those settings are too low, but I've > honestly no idea how to estimate these other than trial and error. > I've not had the time to really brush up on that level of tuning. Isn't # VACUUM ANALYZE VERBOSE ; showing that info in the end? Or are those only for the current db, not for the server overall? INFO: free space map contains 32526 pages in 68 relations DETAIL: A total of 31648 page slots are in use (including overhead). 31648 page slots are required to track all free space. Current limits are: 150000 page slots, 1000 relations, using 984 kB. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
Attachment:
signature.asc
Description: This is a digitally signed message part.
