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