PostgreSQL Configuration Tool for Dummies - Mailing list pgsql-performance

Now I am at the difficult part, what parameters to calculate and how to calculate them.  Everything below has to do with PostgreSQL version 8.2:

The parameters I would think we should calculate are:

max_connections

shared_buffers

work_mem

maintenance_work_mem

effective_cache_size

random_page_cost

Any other variables?  I am open to suggestions.

Calculations based on values supplied in the questions at the top of the page:

max_connection= question #3 or a minimum of 8

effective_cache_size={question #2}MB

maintenance_work_mem= ({question #2} * .1) MB

Any thoughts on the other variables based on the questions found at the top of the below web page?

http://www.webservices.uiuc.edu/postgresql/

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu