| From: | Markus Schiltknecht <markus(at)bluegap(dot)ch> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
| 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:44:24 |
| Message-ID: | 466D6DD8.5060201@bluegap.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig James | 2007-06-11 15:44:30 | Re: Best way to delete unreferenced rows? |
| Previous Message | Heikki Linnakangas | 2007-06-11 15:34:34 | Re: dbt2 NOTPM numbers |