PGCon2012 - Final Release
PGCon 2012
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Jignesh K. Shah |
| Schedule | |
|---|---|
| Day | Talks - 2 - Friday - 2012-05-18 |
| Room | MRT 205 |
| Start time | 13:30 |
| Duration | 01:00 |
| Info | |
| ID | 387 |
| Event type | Lecture |
| Track | Performance |
| Language used for presentation | English |
OLTP Performance Benchmarks Overview
Learn about various OLTP Performance benchmark kits , when to use them and what to know when comparing numbers with other databases.
pgbench is widely used for micro benchmarking PostgreSQL. However many customers use benchmarks based on the databases prevalent in their environment. MySQL - sysbench SQLServer - TPC-C, DVDStore Oracle - TPC-C and so on.
In this session we look at these OLTP Benchmarks like sysbench, dbt2 (TPC-C like), BenchmarkSQL (TPC-C Like), DVDStore, etc and see how to optimize PostgreSQL for these benchmarks and points for consideration when comparing them to other databases.