Skip site navigation (1) Skip section navigation (2)

pgbench results on a new server

From: Craig James <craig_james(at)emolecules(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: pgbench results on a new server
Date: 2010-06-25 18:53:01
Message-ID: 4C24FB0D.4020701@emolecules.com (view raw or flat)
Thread:
Lists: pgsql-performance
I've got a new server and want to make sure it's running well.  Are these pretty decent numbers?

8 cores (2x4 Intel Nehalem 2 GHz)
12 GB memory
12 x 7200 SATA 500 GB disks
3WARE 9650SE-12ML RAID controller with BBU
   WAL on ext2, 2 disks: RAID1 500GB, blocksize=4096
   Database on ext4, 8 disks: RAID10 2TB, stripe size 64K, blocksize=4096
Ubuntu 10.04 LTS (Lucid)
Postgres 8.4.4

pgbench -i -s 100 -U test
pgbench -c 5 -t 20000 -U test
tps = 4903
pgbench -c 10 -t 10000 -U test
tps = 4070
pgbench -c20 -t 5000 -U test
tps = 5789
pgbench -c30 -t 3333 -U test
tps = 6961
pgbench -c40 -t 2500 -U test
tps = 2945

Thanks,
Craig



In response to

Responses

pgsql-performance by date

Next:From: Rajesh Kumar MallahDate: 2010-06-25 19:00:35
Subject: Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.)
Previous:From: Greg SmithDate: 2010-06-25 18:48:07
Subject: Any recent AMD purchases?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group