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


---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html



Reply via email to