From: ml@bortal.de <ml@bortal.de>
To: pgsql-performance@postgresql.org
Subject: Postgres benchmarking with pgbench
Date: Mon, 16 Mar 2009 11:48:36 +0100
Message-ID: <49BE2E84.2040506@bortal.de> (raw)
Hello List,
i would like to pimp my postgres setup. To make sure i dont have a slow
hardware, i tested it on three diffrent enviorments:
1.) Native Debian Linux (Dom0) and 4GB of RAM
2.) Debian Linux in Xen (DomU) 4GB of RAM
3.) Blade with SSD Disk 8GB of RAM
Here are my results: http://i39.tinypic.com/24azpxg.jpg
Here is my postgres config: http://pastebin.com/m5e40dbf0
Here is my sysctl:
----------------------------------
kernel.shmmax = 3853361408
kernel.shmall = 99999999
Here is my pgbench benchmark script: http://pastebin.com/m676d0c1b
Here are my hardware details:
========================
On Hardware 1 + 2 (native linux and debian) i have the following
Hardware underneath:
--------------------------------------------------------------------------------------------------------------------------------------------------------
- ARC-1220 8-Port PCI-Express on Raid6 with normal SATA drives 7200RPM
- 1x Quadcore Intel(R) Xeon(R) CPU E5320 @ 1.86GHz
The Blade:
----------------------------
- 2x 16GB SSD set up in striping mode (Raid 0)
- 2x Quardcore Intel(R) Xeon(R) CPU E5420 @ 2.50GHz
Any idea why my performance colapses at 2GB Database size?
Thanks,
Mario
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: ml@bortal.de
Subject: Re: Postgres benchmarking with pgbench
In-Reply-To: <49BE2E84.2040506@bortal.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