Re: PATCH: postpone building buckets to the end of Hash (in HashJoin)

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: PATCH: postpone building buckets to the end of Hash (in HashJoin)
Дата
Msg-id 56732909.1070304@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: PATCH: postpone building buckets to the end of Hash (in HashJoin)  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: PATCH: postpone building buckets to the end of Hash (in HashJoin)  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Hi,

On 12/17/2015 07:20 PM, Robert Haas wrote:
...
>
> If this doesn't regress performance in the case where the number of
> buckets is estimated accurately to begin with, then I think this is
> a great idea. Can you supply some performance tests results for that
> case, and maybe some of the other cases also?

I don't see how it could regress performance, and the benchmarks I've 
done confirm that. I'll do more thorough benchmarking and post the 
results here, but not now as this patch is in 2016-01 CF and I want to 
put all my time into reviewing patches from the open commitfest.

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Mart Kelder
Дата:
Сообщение: Re: [PoC] Asynchronous execution again (which is not parallel)
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Remove array_nulls?