Red Hat help


PGSQL_MAX_FSM_PAGES

The PGSQL_MAX_FSM_PAGES variable tells the vacuum process how many pages to look for in the shared free-space map.

Values

Integer

Default

500000

Comments

Each FSM page uses 6 bytes of RAM for administrative overhead, so increasing FSM substantially on systems low on RAM may be counter-productive.

Related questions
What are the right PostgreSQL settings for my site?
More information
Full list of performance-related PosgreSQL parameters
PosgreSQL performance tips from the experts