Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 245A79FB99F
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 11 Jun 2007 12:46:18 -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 35768-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 11 Jun 2007 12:45:25 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from nabagan.bluegap.ch (nabagan.bluegap.ch [88.198.58.248])
	by postgresql.org (Postfix) with ESMTP id 5ED7F9FB846
	for <pgsql-performance@postgresql.org>;
	Mon, 11 Jun 2007 12:45:25 -0300 (ADT)
Received: from [192.168.0.232] (berlin.programmfabrik.de
	[::ffff:213.221.101.147])
	(AUTH: CRAM-MD5 markus@bluegap.ch, TLS: TLSv1/SSLv3, 256bits,
	AES256-SHA)
	by nabagan.bluegap.ch with esmtp; Mon, 11 Jun 2007 18:38:44 +0200
	id 00250A3C.466D7A94.000024C6
Message-ID: <466D6DD8.5060201@bluegap.ch>
Date: Mon, 11 Jun 2007 17:44:24 +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: Jim Nasby <decibel@decibel.org>, PFC <lists@peufeu.com>,
	pgsql-performance@postgresql.org
Subject: Re: dbt2 NOTPM numbers
References: <466428F7.5010808@bluegap.ch> <46642B33.6030101@enterprisedb.com>
	<46642F2E.3080509@bluegap.ch> <op.tteow6v7cigqcu@apollo13>
	<46646065.50806@bluegap.ch>
	<47BE2772-D774-4E2C-9D02-FD24C9F6BB90@decibel.org>
	<466D6A9E.4010703@bluegap.ch> <466D6B8A.6030509@enterprisedb.com>
In-Reply-To: <466D6B8A.6030509@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/191
X-Sequence-Number: 25224

Heikki Linnakangas wrote:
> Markus Schiltknecht wrote:
>> For dbt2, I've used 500 warehouses and 90 concurrent connections, 
>> default values for everything else.
> 
> 500? That's just too much for the hardware. Start from say 70 warehouses 
> and up it from there 10 at a time until you hit the wall. I'm using 30 
> connections with ~100 warehouses on somewhat similar hardware.

Aha! That's why...  I've seen the '500' in some dbt2 samples and thought 
it'd be a good default value.

But it makes sense that the benchmark doesn't automatically 'scale down'...

Stupid me.

Thanks again! Hoping for larger NOTPMs.

Regards

Markus