Re: Use merge-based matching for MCVs in eqjoinsel

From: David Geier <geidav(dot)pg(at)gmail(dot)com>
To: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Use merge-based matching for MCVs in eqjoinsel
Date: 2025-10-27 15:50:33
Message-ID: c6fd168d-2c18-4bc7-b256-f33408391570@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Ilia!

On 10.09.2025 15:56, Ilia Evdokimov wrote:
>
> LGTM. Yes, I'll test this patch.
>
>
>
> 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.
>

Have you had a chance to test above things?

I've seen that there's already a commit fest entry. I've adapted the
entry (changed the title and added myself as author). Do you want to add
yourself as reviewer?

--
David Geier

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Maxim Orlov 2025-10-27 15:54:35 Re: POC: make mxidoff 64 bits
Previous Message Jacob Champion 2025-10-27 15:33:57 Re: Remove specific \r\n code in TAP for Windows