PGCon2007 - Confirmed

PGCon 2007
The PostgreSQL Conference

Josh Berkus
Day 1
Room SITE F0126
Start time 13:00
Duration 03:00
ID 45
Event type Workshop
Track Tutorial
Language English

Performance Whack-a-Mole

Methodology for troubleshooting database application performance

Core team member Josh Berkus will take you through his step-by-step method for analyzing and troubleshooting database application performance bottlenecks.

Every database application has at least one performance issue, and most have several. Troubleshooting these is like a game of "whack-a-mole" where each resolved issue just allows you to see the next problem. Since performance troubleshooting is a big part of the job of professional PostgreSQL DBAs and database consultants, it's important to know how to do this methodically and well.

Josh Berkus will take you through the step-by-step method he uses to analyze and troubleshoot applications and public database benchmarks, including:

  • Hardware configuration
  • PostgreSQL configuration
  • Finding troublesome queries
  • Fixing troublesome queries
  • Connection pooling and middleware issues
  • Application design issues
This half-day tutorial will also include going over the latest information on PostgreSQL configuration parameters and recent developments in performance analysis tools.