Re: dbt2 NOTPM numbers

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Markus Schiltknecht <markus(at)bluegap(dot)ch>
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:34:34
Message-ID: 466D6B8A.6030509@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Schiltknecht 2007-06-11 15:44:24 Re: dbt2 NOTPM numbers
Previous Message Andrew Sullivan 2007-06-11 15:34:14 Re: How much ram is too much