A Guide to PostgreSQL Performance Tuning
The default PostgreSQL configuration is a rock-solid setup targeted at everyone's best guess at how an "average" database on "average" hardware should be set up. This article is intended to assist all levels of PostgreSQL users in better understanding PostgreSQL performance tuning.