PGCon2007 - Confirmed
PGCon 2007
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Josh Berkus |
| Schedule | |
|---|---|
| Day | 1 |
| Room | SITE F0126 |
| Start time | 13:00 |
| Duration | 03:00 |
| Info | |
| ID | 45 |
| Event type | Workshop |
| Track | Tutorial |
| Language | English |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
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