Re: Introduce join_info_array for direct lookups of SpecialJoinInfo by ojrelid

2023-09-06 Thread Richard Guo
On Mon, May 8, 2023 at 10:30 AM Richard Guo 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 perfor

Re: Introduce join_info_array for direct lookups of SpecialJoinInfo by ojrelid

2023-05-07 Thread Richard Guo
On Thu, May 4, 2023 at 4:07 PM Richard Guo wrote: > When working on the improper qual pushdown issue [1], there is a need in > the proposed fix to avoid scanning all the SpecialJoinInfos, since that > is too expensive. I think this might be a common requirement. In the > current codes there are

Introduce join_info_array for direct lookups of SpecialJoinInfo by ojrelid

2023-05-04 Thread Richard Guo
When working on the improper qual pushdown issue [1], there is a need in the proposed fix to avoid scanning all the SpecialJoinInfos, since that is too expensive. I think this might be a common requirement. In the current codes there are several places where we need to scan all the SpecialJoinInf