PGCon2009 - Final Release
PGCon 2009
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Josh Berkus |
| Schedule | |
|---|---|
| Day | Tutorials - first day - 2009-05-19 |
| Room | DMS 1110 |
| Start time | 13:00 |
| Duration | 03:00 |
| Info | |
| ID | 188 |
| Event type | Other |
| Track | Tutorial |
| Language used for presentation | English |
Performance Whack-a-Mole II
The Moles Are Back, and Bigger Than Ever
"The database is slow!"
How often you've heard that plaintive cry from your co-workers, customers or client. In this tutorial, Josh Berkus will explain his simple methodology for resolving database application performance problems. He'll also demonstrate some of the OS and PostgreSQL tools available for troubleshooting performance problems and show how to use them.
"The database is slow!"
How often you've heard that plaintive cry from your co-workers, customers or client. In this tutorial, Josh Berkus will explain his simple methodology for resolving database application performance problems. He'll also demonstrate some of the OS and PostgreSQL tools available for troubleshooting performance problems ("Moles") and show how to use them.
Topics covered will include:
- The Principles of Mole-hunting.
- Baselining
- How to start looking for Moles
- Tools for Mole-hunting a. Operating system tools b. PostgreSQL tools
- Examples of mole-hunting
In this second edition of the talk, Josh will also cover new tools available with PostgreSQL versions 8.3 and 8.4, including CSV logging, pgstatstatements and auto_explain, as well as improved Linux tools for performance analysis.