PGCon2010 - Final Release III
PGCon 2010
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Zach Conrad |
| Schedule | |
|---|---|
| Day | Tutorials - 2 - 2010-05-19 |
| Room | DMS 1110 |
| Start time | 09:00 |
| Duration | 03:00 |
| Info | |
| ID | 213 |
| Event type | Workshop |
| Track | Tutorial |
| Language used for presentation | English |
Realistic Load Testing
HOWTO set up a realistic testing environment using PostgreSQL Functions and Python
Applications and databases need testing. But how can you get valid results for a fully integrated system Flight-Check test at realistic loads? This tutorial addresses the many challenges that arise in an application or database development to give confidence to you and your customers in presenting a production-ready product.
After running into many obstacles in proving a recent enterprise product launch could handle the expected loads of our customers, Digitec, Inc. invested time in writing realistic Flight-Check tests using PostgreSQL functions and Python. The results of these tests gave confidence to the engineers, developers, and our customers that the entire system would be able to perform as designed.
Topics covered during this tutorial include: * Shortfalls of FLOSS benchmark tests * Identifying the Project Test Components * Identifying Realistic Loads * Identifying Historical Data * Developing Tests and Procedures * PostgreSQL Functions for Tests * Python Scripts for Tests * Helpful Tools