Adjust max_fsm_pages
Problem:
|
I am currently receiving the following error message on my postgres 8.1 install after a vacuum analyse.
NOTICE: number of page slots needed (1623232) exceeds max_fsm_pages (52428
HINT: Consider increasing the configuration parameter "max_fsm_pages" to a value over 1623232.
|
Solution:
Locate the postgres.conf file.
Find the value for max_fsm_pages and set it to it's new value.
Save the file and restart the service.
|
