HELP: optimizing shared mem - Mailing list pgsql-admin

From hal
Subject HELP: optimizing shared mem
Date
Msg-id 29202C90-58C5-11D8-9D66-000A959670A0@cc.usu.edu
Whole thread Raw
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Jeff Boes
Date:
Subject: Re: Contents of pg_listener linger?
Next
From: Shane Wright
Date:
Subject: Re: hanging for 30sec when checkpointing