PostgreSQL Performance Pitstop

General information

• Tuning Your PostgreSQL Server (written with other PostgreSQL contributors)
• 5-Minute Introduction to PostgreSQL Performance
• Inside the PostgreSQL Buffer Cache: slides, sample queries
• The Linux Page Cache and pdflush: Theory of Operation and Tuning for Write-Heavy Loads
• Using and Abusing pgbench (slides)
• Database Hardware Benchmarking (slides) (video of presentation)

The PostgreSQL Performance Workbook

• Introduction to the workbook articles
• Example server information
• Disk performance testing
• Determining the right pgbench database size

Other PostgreSQL Topics

• Checkpoints and the Background Writer: PostgreSQL 8.3 Improvements and Migration
• Tools to automate pgbench
• Installing the PostgreSQL RPMs on RHEL 5
• Tuning PostgreSQL WAL Synchronization
• PostgreSQL Buffer Pool Management
• PostgreSQL 8.2 Performance Monitoring Patchset

PostgreSQL Advocacy

• Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007 (written with other PostgreSQL contributors)
• Transactional DDL in PostgreSQL: A Competitive Analysis
• Working with PostgreSQL and CVS (written with other PostgreSQL contributors)

All these articles were written by Greg Smith who works as a database consultant for for 2ndQuadrant.

Last update 04/07/2010