postgresql, max_fsm_pages on FreeBSD 5.3
cguttesen at yahoo.dk
Mon Mar 14 01:07:10 PST 2005
I'm running a postgresql 7.4.6 db, where the largest
table having 13 mill. records. The db-server is a
quad-opteron with 4 GB RAM.
I've configured shared_buffers to 8192, sort_mem to
4096 and effective_cache_size to 4096.
max_fsm_relations and max_fsm_pages was easy to
configure when I found
(max_fsm_pages and max_fsm_relations). The odd thing
is that according to a vacuum verbose where total
pages needed always seems to be approx. 15.000 pages
larger than what max_fsm_pages is configured to.
So I keept increasing max_fsm_pages, from 60000, 80000
and now 100000. This morning my beloved crontab send
me a verbose vacuum telling me "114848 total pages
max_fsm_relations remains steady at 300 (245 relations
according to the output).
Not that I mind increasing this value, but is there
any limit to this value, or will I reach some
thresshold where this setting will become
The docs says that max_fsm_pages "Sets the maximum
number of disk pages for which free space will be
tracked in the shared free-space map." But what does
that actually mean?
Postgresql does seem to perform better when I tweak
The above mentioned shared buffers, sort mem and
effective cache size did become counterproductive when
I increased them too much.
More information about the freebsd-performance