Re: dbt2 NOTPM numbers

Поиск
Список
Период
Сортировка
От Markus Schiltknecht
Тема Re: dbt2 NOTPM numbers
Дата
Msg-id 466D6DD8.5060201@bluegap.ch
обсуждение исходный текст
Ответ на Re: dbt2 NOTPM numbers  (Heikki Linnakangas <heikki@enterprisedb.com>)
Ответы Re: dbt2 NOTPM numbers  ("Mark Wong" <markwkm@gmail.com>)
Список 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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Craig James
Дата:
Сообщение: Re: Best way to delete unreferenced rows?
Следующее
От: Ansgar -59cobalt- Wiechers
Дата:
Сообщение: Re: test / live environment, major performance difference