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
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html