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

Re: dbt2 NOTPM numbers

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: 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-11 15:44:24
Message-ID: 466D6DD8.5060201@bluegap.ch (view raw or flat)
Thread:
Lists: pgsql-performance
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



In response to

Responses

pgsql-performance by date

Next:From: Craig JamesDate: 2007-06-11 15:44:30
Subject: Re: Best way to delete unreferenced rows?
Previous:From: Heikki LinnakangasDate: 2007-06-11 15:34:34
Subject: Re: dbt2 NOTPM numbers

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