Horton

Re: Use merge-based matching for MCVs in eqjoinsel

David Geier <geidav.pg@gmail.com>

View thread
From: David Geier <geidav.pg@gmail.com>
To: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>, pgsql-hackers@lists.postgresql.org
Date: 2025-10-27T15:50:33Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Speed up eqjoinsel() with lots of MCV entries.

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