pgtune takes the wimpy default postgresql.conf and expands the database server to be as powerful as the hardware it's being deployed on
The pgtune, postgresql.conf tuning wizardproject is a PostgreSQL Community project that is a part of the pgFoundry.
The pgFoundry page for the project is at http://pgfoundry.org/projects/pgtune, where you can find downloads, documentation, bug reports, mailing lists, and a whole lot more.