PGCon2010 - Final Release III

PGCon 2010
The PostgreSQL Conference

Zach Conrad
Day Tutorials - 2 - 2010-05-19
Room DMS 1110
Start time 09:00
Duration 03:00
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