PGCon2010 - Final Release III
PGCon 2010
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Josh Berkus |
| Schedule | |
|---|---|
| Day | Tutorials - 1 - 2010-05-18 |
| Room | DMS 1110 |
| Start time | 13:00 |
| Duration | 03:00 |
| Info | |
| ID | 223 |
| Event type | Workshop |
| Track | Tutorial |
| Language used for presentation | English |
Server Health Check
Give your Postgres server a checkup
Have you given your PostgreSQL database server a checkup lately? If not, you probably should. "Sick" database servers are easy to prevent if you take a few simple steps <i>before</i> your server comes down with something.
Just as regular doctor's checkups help spot disease and chronic health problems in people before they become acute, a "health check" of your PostgreSQL servers will uncover and sometimes prevent database server problems before your website goes down. Vetran database server medic Josh Berkus will go through the various steps PostgreSQL Experts normally takes to make sure customer database servers are "healthy".
A regular health check generally includes: * Configuration checkup * Hardware checkup * Resource usage checkup * OS Checkup * Application checkup * Slow query checkup
After we've determined the server is "healthy" we then proceed with monitoring and change control setup to make sure it stays healthy, including: * monitoring the database server * monitoring the OS * configuration change management
This tutorial will include the details, scripts and tools for all of the above checkups. Become a database medic yourself! Make your database servers healthy.