Performance Optimization
From PostgreSQL Wiki
Contents |
General Setup and Optimization
- Tuning Your PostgreSQL Server by Greg Smith, Robert Treat, and Christopher Browne
- GUCs: A Three Hour Tour by Josh Berkus. Also useful here is his tuning OpenOffice spreadsheet, which suggests tuning values for 5 different types of workloads.
- QuickStart Guide to Tuning PostgreSQL by Christopher Browne
- 5-Minute Introduction to PostgreSQL Performance by Greg Smith
- Annotated postgresql.conf by Josh Berkus and Shridhar Daithankar (older version of material covered in the GUC tour referenced above)
- Performance Tuning by Josh Berkus and Shridhar Daithankar
- Replacing Slow Loops in PostgreSQL by Joel Burton
- PostgreSQL Hardware Performance Tuning by Bruce Momjian
- The effects of data fragmentation in a mixed load database by Dmitry Dvoinikov
- PostgreSQL Performance Features in 8.3 by Simon Riggs
Performance courses are available from a number of companies. Check events and trainings for further details.
Critical maintenance for performance
- Introduction to VACUUM, ANALYZE, EXPLAIN, and COUNT by Jim Nasby.
- Planner Statistics
- Using EXPLAIN
- Logging Difficult Queries
- Logging Checkpoints
- Checkpoints and the Background Writer: PostgreSQL 8.3 Improvements and Migration by Greg Smith
Disk and hardware setup
- Testing your disks for PostgreSQL by Greg Smith
- Ext2 vs Ext3 on 50 spindles by Joshua Drake
- Dell md1000 bonnie++ benchmarks by Merlin Moncure
- SCSI vs. IDE/SATA Disks
- Direct Storage vs. SAN
- Community Disk Tuning Guide (work in progress)
Additional helpful manual sections
- Populating a Database: covers bulk-loading
Benchmark Workloads
Performance and Scaling Reports
- PgCon 2008 Benchmark and Scaling Update by Jignesh Shah, et all (Sun)
- HP ProLiant DL380 G5 Tuning Guide
