Re: [COMMITTERS] pgsql: Improve performance offind_all_inheritors()

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: [COMMITTERS] pgsql: Improve performance offind_all_inheritors()
Дата
Msg-id 20170328195914.GA2265@e733.localdomain
обсуждение исходный текст
Ответы Re: [COMMITTERS] pgsql: Improve performance of find_all_inheritors()  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi, Robert.

> I'm a little worried that this will be noticeably slower when the
> number of partitions is small, like 4 or 8 or 16.  In other places,
> we've found it necessary to support both a list-based strategy and a
> hash-based strategy to avoid regressing small cases (e.g.
> join_rel_list + join_rel_hash in PlannerInfo, ResourceArray in
> resowner.c, etc).

I've checked it [1]. Apparently in this particular case patches make code
faster on small amount of partitions as well.

[1] https://postgr.es/m/20170324132258.GB16830%40e733.localdomain

--
Best regards,
Aleksander Alekseev

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

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Monitoring roles patch
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Monitoring roles patch