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'...
Thanks again! Hoping for larger NOTPMs.
In response to
pgsql-performance by date
|Next:||From: Craig James||Date: 2007-06-11 15:44:30|
|Subject: Re: Best way to delete unreferenced rows?|
|Previous:||From: Heikki Linnakangas||Date: 2007-06-11 15:34:34|
|Subject: Re: dbt2 NOTPM numbers|