Skip site navigation (1) Skip section navigation (2)

Re: dbt2 NOTPM numbers

From: "Mark Wong" <markwkm(at)gmail(dot)com>
To: "Markus Schiltknecht" <markus(at)bluegap(dot)ch>
Cc: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, "Jim Nasby" <decibel(at)decibel(dot)org>, PFC <lists(at)peufeu(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: dbt2 NOTPM numbers
Date: 2007-06-13 16:33:22
Message-ID: 70c01d1d0706130933p2a9a348coa4d3c3bbf607c65a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 6/11/07, Markus Schiltknecht <markus(at)bluegap(dot)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

In response to

Responses

pgsql-performance by date

Next:From: RESTOUXDate: 2007-06-13 16:33:53
Subject: [PG 8.1.0 / AIX 5.3] Vacuum processes freezing
Previous:From: Michael DenglerDate: 2007-06-13 16:12:39
Subject: Re: WAL shipping and ever expanding pg_xlog

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group