Hi Everyone, Just wondering what the maximum reasonable free space map setting should be? I'm receiving the following advice from vacuum:
INFO: free space map contains 170803 pages in 117 relations DETAIL: A total of 185000 page slots are in use (including overhead). 733008 page slots are required to track all free space. Current limits are: 185000 page slots, 5000 relations, using 1623 KB. NOTICE: number of page slots needed (733008) exceeds max_fsm_pages (185000) HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 733008. I thought 185K was pretty high, is going to 700K+ reasonable? I've got 16GB of ram and am running very high volume 100GB+ DBs. Cheers Phil -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
