PGCon2012 - Final Release

PGCon 2012
The PostgreSQL Conference

Jignesh K. Shah
Day Talks - 2 - Friday - 2012-05-18
Room MRT 205
Start time 13:30
Duration 01:00
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.