Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id D83D19FBCFB
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue,  5 Jun 2007 11:25:44 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 08425-06-5
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue,  5 Jun 2007 11:25:36 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from nabagan.bluegap.ch (nabagan.bluegap.ch [88.198.58.248])
	by postgresql.org (Postfix) with ESMTP id 629449FBCDD
	for <pgsql-performance@postgresql.org>;
	Tue,  5 Jun 2007 11:25:36 -0300 (ADT)
Received: from [192.168.77.28] (p54BD8AE4.dip0.t-ipconnect.de
	[::ffff:84.189.138.228])
	(AUTH: CRAM-MD5 markus@bluegap.ch, TLS: TLSv1/SSLv3, 256bits,
	AES256-SHA)
	by nabagan.bluegap.ch with esmtp; Tue, 05 Jun 2007 17:19:43 +0200
	id 00604446.46657F0F.00000FAE
Message-ID: <4665725D.6060102@bluegap.ch>
Date: Tue, 05 Jun 2007 16:25:33 +0200
From: Markus Schiltknecht <markus@bluegap.ch>
User-Agent: Icedove 1.5.0.10 (X11/20070329)
MIME-Version: 1.0
To: Heikki Linnakangas <heikki@enterprisedb.com>
CC: pgsql-performance@postgresql.org
Subject: Re: dbt2 NOTPM numbers
References: <466428F7.5010808@bluegap.ch> <46642B33.6030101@enterprisedb.com>
	<46642F2E.3080509@bluegap.ch> <4664748B.2060304@enterprisedb.com>
	<4665703E.3040905@bluegap.ch> <46657180.7010604@enterprisedb.com>
In-Reply-To: <46657180.7010604@enterprisedb.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/68
X-Sequence-Number: 25101

Hi,

Heikki Linnakangas wrote:
> Maybe, TPC-C is very write-intensive. I don't know much about RAID 
> stuff, but I think you'd really benefit from a separate WAL drive. You 
> could try turning fsync=off to see if that makes a difference.

Hm.. good idea, I'll try that.

> Oh, and how many connections are you using? DBT-2 can be quite sensitive 
> to that. 30 seems to work pretty well for me.

I've been using between 2 and 90, but that made pretty much no 
difference at all. I'm not getting anything more that some 300 NOTPM.

Regards

Markus