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.
In response to
pgsql-performance by date
|Next:||From: Markus Schiltknecht||Date: 2007-06-11 15:44:24|
|Subject: Re: dbt2 NOTPM numbers|
|Previous:||From: Andrew Sullivan||Date: 2007-06-11 15:34:14|
|Subject: Re: How much ram is too much|