PostgreSQL. PostgreSQL is an open source, community driven, standard compliant object-relational database system.
This document describes how to set up PostgreSQL. It also describes how to configure PostgreSQL to be accessible from a remote client. If you need help setting up the rest of a web stack, see the LAMP page and follow all of the sections except the one related to MySQL. Before you start. Performance Tuning PostgreSQL. By Frank Wiles 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. The problem is that every database is not only different in its design, but also its requirements. Annexe E. PostgreSQL et les index.