Introduction PostgreSQL is the most advanced and flexible Open Source SQL database today. With this power and flexibility comes a problem. How do the PostgreSQL developers tune the default configuration for everyone? Unfortunately the answer is they can't.
Really good, comprehensive introduction to tuning Postgres. Performance Tuning PostgreSQL | 
