PostgreSQL Performance Pitstop

General information

• 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

The PostgreSQL Performance Workbook

• Introduction to the workbook articles
• Example server information
• Disk performance testing
• Determining the right pgbench database size
• Next installments, coming soon: Graphing pgbench results and Optimizing for an INSERT workload

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
• Transactional DDL in PostgreSQL: A Competitive Analysis

Current work in progress

• Working with PostgreSQL and CVS (written with other PostgreSQL contributors)

All these articles were written by Greg Smith who is currently working as a software engineer for Truviso.

Last update 10/10/2007