From: Felix Schubert <input@fescon.de>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Slow Performance on a XEON E5504
Date: Sat, 25 Aug 2012 14:07:34 +0200
Message-ID: <28C5C61F-5ADE-4AD5-9E27-61DC482398A2@fescon.de> (raw)
Hello List,
I've got a system on a customers location which has a XEON E5504 @ 2.00GHz Processor (HP Proliant)
It's postgres 8.4 on a Debian Squeeze System running with 8GB of ram:
The Postgres Performance on this system measured with pgbench is very poor:
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 158.283272 (including connections establishing)
tps = 158.788545 (excluding connections establishing)
The same database on a Core i7 CPU 920 @ 2.67GHz, 8 cores with 8GB RAM same distro and Postgresql Version is much faster:
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 1040.534002 (including connections establishing)
tps = 1065.215134 (excluding connections establishing)
Even optimizing the postgresql.conf values doesn't change a lot on the tps values. (less than 10%)
Tried Postgresql 9.1 on the Proliant:
transaction type: TPC-B (sort of)
scaling factor: 1
query mode: simple
number of clients: 40
number of threads: 1
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 53.114978 (including connections establishing)
tps = 53.198667 (excluding connections establishing)
Next was to compare the diskperformance which was much better on the XEON than on the Intel i7.
Any idea where to search for the bottleneck?
best regards,
Felix Schubert
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: input@fescon.de
Subject: Re: Slow Performance on a XEON E5504
In-Reply-To: <28C5C61F-5ADE-4AD5-9E27-61DC482398A2@fescon.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox