On Thu, 6 Dec 2007, Reece Hart wrote:
> This seems to directly say that the commented out settings are the
> default values, and furthermore that one must restart to get the
> indicated default back. Based on your evidence, it seems that the
> postgresql.conf comment for max_fsm_pages needs revising to indicate
> that the m_f_p default is determined at initdb-time.
Yes, the commented out values are the defaults, but after initdb
max_fsm_pages is not commented out, which is why I'm suggesting you or
some other admin modified your file. Try this test:
$ ./tmp/82/bin/initdb -D fsmtest > fsmlog 2>&1
$ grep max_fsm fsmlog
selecting default shared_buffers/max_fsm_pages ... 24MB/153600
$ grep max_fsm_pages fsmtest/postgresql.conf
max_fsm_pages = 153600 # min max_fsm_relations*16, 6 bytes each
So you can see max_fsm_pages is not commented out, so it is not the true
default (20000).
Kris Jurka