From: Markus Schiltknecht <markus@bluegap.ch>
To: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: Jim Nasby <decibel@decibel.org>
Cc: PFC <lists@peufeu.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: dbt2 NOTPM numbers
Date: Mon, 11 Jun 2007 17:44:24 +0200
Message-ID: <466D6DD8.5060201@bluegap.ch> (raw)
In-Reply-To: <466D6B8A.6030509@enterprisedb.com>
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>
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
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: markus@bluegap.ch, heikki@enterprisedb.com, decibel@decibel.org, lists@peufeu.com
Subject: Re: dbt2 NOTPM numbers
In-Reply-To: <466D6DD8.5060201@bluegap.ch>
* 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