From: Mark Wong <markwkm@gmail.com>
To: Markus Schiltknecht <markus@bluegap.ch>
Cc: 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: Wed, 13 Jun 2007 09:33:22 -0700
Message-ID: <70c01d1d0706130933p2a9a348coa4d3c3bbf607c65a@mail.gmail.com> (raw)
In-Reply-To: <466D6DD8.5060201@bluegap.ch>
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>
<466D6DD8.5060201@bluegap.ch>
On 6/11/07, Markus Schiltknecht <markus@bluegap.ch> wrote:
> 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.
Yeah, I ran with 500+ warehouses, but I had 6 14-disk arrays of 15K
RPM scsi drives and 6 dual-channel controllers... :)
Regards,
Mark
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: markwkm@gmail.com, markus@bluegap.ch, heikki@enterprisedb.com, decibel@decibel.org, lists@peufeu.com
Subject: Re: dbt2 NOTPM numbers
In-Reply-To: <70c01d1d0706130933p2a9a348coa4d3c3bbf607c65a@mail.gmail.com>
* 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