I am running Postgresql-7.3.2 on FreeBSD 4.7 with 512M of mem.
The application is a web based data warehouse with ~200 users.
I am trying to optimize performance. In postgresql.conf I
have set:
shared_buffers to 16000
sort_mem to 8000
What are max_fsm_relations and max_fsm_pages and what should
they be set to?
Just in case there are some FreeBSD Wizards in the group,
how do I lock the kernel buffers in memory?
hal