Re: Introduce join_info_array for direct lookups of SpecialJoinInfo by ojrelid

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: Introduce join_info_array for direct lookups of SpecialJoinInfo by ojrelid
Дата
Msg-id CAMbWs49rGgCwEdLSjUJ6eOt6CUsq9weHQ8bo0+TQFNjmxobprQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Introduce join_info_array for direct lookups of SpecialJoinInfo by ojrelid  (Richard Guo <guofenglinux@gmail.com>)
Список pgsql-hackers
Дерево обсуждения

On Mon, May 8, 2023 at 10:30 AM Richard Guo <guofenglinux@gmail.com> wrote:
I'd like to devise a test query that shows performance gain from this
patch, but I'm not sure how to do that.  May need help here.

I've been trying for some time but still haven't been able to come up
with a test case that shows the performance improvement of this patch.
My best guess is that situations that can benefit from direct lookups of
SpecialJoinInfo are pretty rare, and the related codes are not in the
critical path.  So for now I think I'd better withdraw this patch to
avoid people wasting time reviewing it.

Thanks
Richard

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

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: Improving the heapgetpage function improves performance in common scenarios
Следующее
От: Amit Langote
Дата:
Сообщение: Re: generic plans and "initial" pruning