Improve the performance of nested loop join in the case of partitioned inner table

Поиск
Список
Период
Сортировка
От Alexandr Nikulin
Тема Improve the performance of nested loop join in the case of partitioned inner table
Дата
Msg-id CAHdr9ueefdCCCq1mXAYfLmRgEKfhWQDCU7=XmureEAzJcOwfag@mail.gmail.com
обсуждение исходный текст
Ответы Re: Improve the performance of nested loop join in the case of partitioned inner table  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
Hi, hackers

I propose to slightly improve the performance of nested loop join in the case of partitioned inner table.
As I see in the code, the backend looks for the partition of the inner table each time after fetch a new row from the outer table.
These searches can take a significant amount of time.
But we can skip this step if the nested loop parameter(s) was(re) not changed since the previous row fetched from the outer table

The draft patch is attached.
Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: ICU locale validation / canonicalization
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Data is copied twice when specifying both child and parent table in publication