Re: Use merge-based matching for MCVs in eqjoinsel - Mailing list pgsql-hackers

From Ilia Evdokimov
Subject Re: Use merge-based matching for MCVs in eqjoinsel
Date
Msg-id 63b35674-6706-42db-bb8d-92ce03226d12@tantorlabs.com
Whole thread Raw
In response to Re: Use merge-based matching for MCVs in eqjoinsel  (David Geier <geidav.pg@gmail.com>)
List pgsql-hackers
Hi!

On 09.09.2025 12:22, David Geier wrote:
> Could you please do that with the latest attached patch so that we test
> it once more?


LGTM. Yes, I'll test this patch.

>
> Could you also run once more the JOB benchmark to get some test coverage
> on the SEMI join code (assuming it also uses SEMI joins)?


Unfortunately, the JOB benchmark does not contain semi join nodes. 
However, TPC-DS does. I'll look for the queries with slowest planner 
times there and check them.

I'll need some time to check both join and semi join cases with small 
and large default_statistics_target. I'll share the results later.

>
> Once we've concluded on above and there are no objections, I will
> register this patch in the commit fest.


Sure. No problem.

-- 
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com




pgsql-hackers by date:

Previous
From: Natalya Aksman
Date:
Subject: Re: Adding skip scan (including MDAM style range skip scan) to nbtree
Next
From: Robert Haas
Date:
Subject: Re: plan shape work