PostgreSQL 9.0 High Performance
Performance of historical PostgreSQL releases
PostgreSQL or another database?
PostgreSQL application scaling lifecycle
Performance tuning as a practice
Reliable controller and disk setup
Database Hardware Benchmarking
Solaris and FreeBSD filesystems
Memory units in the postgresql.conf
Increasing UNIX shared memory parameters for larger buffer sizes
Crash recovery and the buffer cache
Database buffer cache versus operating system cache
Analyzing buffer cache contents
Interacting with the live configuration
Transaction visibility with multiversion concurrency control
Detailed data and index page monitoring
Graphing results with pgbench-tools
Sources for bad results and variation
Transaction Processing Performance Council benchmarks
Index creation and maintenance
Other query planning parameters
Executing other statement types
Database Activity and Statistics
Buffer, background writer, and checkpoint activity
Special application requirements
Other interesting replication projects
Horizontal partitioning with PL/Proxy