Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 45B649FBCA7
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  4 Jun 2007 13:44:19 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 85957-10 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  4 Jun 2007 13:44:15 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from h07.llord.com (unknown [195.140.142.194])
	by postgresql.org (Postfix) with ESMTP id 854409FBC71
	for <pgsql-performance@postgresql.org>;
	Mon,  4 Jun 2007 13:44:16 -0300 (ADT)
Received: from par69-8-88-161-102-87.fbx.proxad.net ([88.161.102.87]
	helo=apollo13) by h07.llord.com with esmtpa (Exim 4.66)
	(envelope-from <lists@peufeu.com>)
	id 1HvFf6-0007VD-2z; Mon, 04 Jun 2007 18:44:08 +0200
Date: Mon, 04 Jun 2007 18:47:20 +0200
To: "Markus Schiltknecht" <markus@bluegap.ch>,
	"Heikki Linnakangas" <heikki@enterprisedb.com>
Subject: Re: dbt2 NOTPM numbers
From: PFC <lists@peufeu.com>
Cc: pgsql-performance@postgresql.org
Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8
MIME-Version: 1.0
References: <466428F7.5010808@bluegap.ch> <46642B33.6030101@enterprisedb.com>
	<46642F2E.3080509@bluegap.ch>
Content-Transfer-Encoding: Quoted-Printable
Message-ID: <op.tteow6v7cigqcu@apollo13>
In-Reply-To: <46642F2E.3080509@bluegap.ch>
User-Agent: Opera Mail/9.10 (Linux)
X-PopBeforeSMTPSenders: junk@peufeu.com, lists@peufeu.com, peufeu@peufeu.com,
	pfcaillaud@peufeu.com
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - h07.llord.com
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - peufeu.com
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.445 tagged_above=0 required=5 tests=AWL=-0.331,
	BAYES_50=0.001, RCVD_IN_NJABL_SPAM=2.775
X-Spam-Level: **
X-Archive-Number: 200706/32
X-Sequence-Number: 25065


> I'll run a bonnie++ first. As the CPUs seem to be idle most of the tim=
e  =

> (see the vmstat.out below), I'm suspecting the RAID or disks.

	You have a huge amount of iowait !
	Did you put the xlog on a separate disk ?
	What filesystem do you use ?
	Did you check that your BBU cache works ?

	For that run a dumb script which does INSERTS in a test table in  =

autocommit mode ; if you get (7200rpm / 60) =3D 120 inserts / sec or les=
s,  =

the good news is that your drives don't lie about fsync, the bad news is=
  =

that your BBU cache isn't working...