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
