PUBLIC MARKS from ogrisel with tags postgresql & database

This is a set of rules of thumb for setting up your PostgreSQL 8.0 server. A lot of the below is based on anecdotal evidence or practical scaling tests; there's a lot about database performance that we, and OSDL, are still working out. However, this should get you started. All information below is useful as of January 12, 2005 and will likely be updated later. Discussions of settings below supercede the recommendations I've made on General Bits.

First mail of a thread on the postgresql mailing list dealing of various ways to implement a tree structure with PostgreSQL.