Re: dbt2 NOTPM numbers - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: dbt2 NOTPM numbers
Date
Msg-id 466D6B8A.6030509@enterprisedb.com
Whole thread Raw
In response to Re: dbt2 NOTPM numbers  (Markus Schiltknecht <markus@bluegap.ch>)
Responses Re: dbt2 NOTPM numbers
List pgsql-performance
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.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: How much ram is too much
Next
From: Christo Du Preez
Date:
Subject: test / live environment, major performance difference