Benchmarking PostgreSQL on Windows Azure VMs

Out of curiosity I benchmarked a vanilla PostgreSQL install on a Medium sized VM on Azure.

I used the pgbench tool, with transactions set to 1000.

I didn’t do any performance tuning, or attempt to move the data onto separate disks.

Ubuntu Server 13.10

starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
number of transactions per client: 1000
number of transactions actually processed: 1000/1000
tps = 56.782699 (including connections establishing)
tps = 56.827597 (excluding connections establishing)

Windows Server 2012 R2 SP1

starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 1
number of threads: 1
number of transactions per client: 1000
number of transactions actually processed: 1000/1000
tps = 96.959695 (including connections establishing)
tps = 97.290895 (excluding connections establishing)

That’s right. Windows is faster, much faster.

Advertisements