Arizona Willie
05-15-2010, 03:42 PM
I went through the database management routine and at the end of vacuuming it has this hint:
DETAIL: A total of 204800 page slots are in use (including overhead).
538032 page slots are required to track all free space.
Current limits are: 204800 page slots, 1000 relations, using 1269 kB.NOTICE: number of page slots needed (538032) exceeds max_fsm_pages (204800)
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 538032.
Total query runtime: 2070673 ms.
=========
How do I do this? And should I? How big should I make the parameter?
DETAIL: A total of 204800 page slots are in use (including overhead).
538032 page slots are required to track all free space.
Current limits are: 204800 page slots, 1000 relations, using 1269 kB.NOTICE: number of page slots needed (538032) exceeds max_fsm_pages (204800)
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 538032.
Total query runtime: 2070673 ms.
=========
How do I do this? And should I? How big should I make the parameter?