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

2023-04-12 Thread Alexandr Nikulin
05, David Rowley : > On Thu, 23 Mar 2023 at 19:46, Alexandr Nikulin > wrote: > > 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 ea

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

2023-03-22 Thread Alexandr Nikulin
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 t