Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id F05C96351F4
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 16 Mar 2009 11:36:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 42119-01
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 16 Mar 2009 11:36:00 -0300 (ADT)
X-Greylist: delayed 01:23:21.553007 by SQLgrey-1.7.6
Received: from eu3sys201aog002.obsmtp.com (eu3sys201aog002.obsmtp.com
	[207.126.148.182])
	by mail.postgresql.org (Postfix) with SMTP id E6EF063456D
	for <pgsql-performance@postgresql.org>;
	Mon, 16 Mar 2009 11:35:32 -0300 (ADT)
Received: from source ([89.110.131.243]) by eu3sys201aob002.postini.com
	([207.126.154.11]) with SMTP
	ID DSNKSb5jtAhzjlnzecv5PHTI0sXZOwyCpDRD@postini.com;
	Mon, 16 Mar 2009 14:35:38 UTC
Received: from [192.168.150.6] (projekte.imos.net [212.87.131.201])
	by nemo.xenovation.com (Postfix) with ESMTP id D27A011D00D4
	for <pgsql-performance@postgresql.org>;
	Mon, 16 Mar 2009 11:48:34 +0100 (CET)
Message-ID: <49BE2E84.2040506@bortal.de>
Date: Mon, 16 Mar 2009 11:48:36 +0100
From: "ml@bortal.de" <ml@bortal.de>
User-Agent: Thunderbird 2.0.0.19 (X11/20090105)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Postgres benchmarking with pgbench
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.3 tagged_above=0 required=5 tests=AWL=2.300
X-Spam-Level: **
X-Archive-Number: 200903/204
X-Sequence-Number: 33126

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