Re: Use merge-based matching for MCVs in eqjoinsel

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2025-09-03T20:26:26Z

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 →

Speed up eqjoinsel() with lots of MCV entries.
- 057012b205a0 19 (unreleased) landed

Ilia Evdokimov <ilya.evdokimov@tantorlabs.com> writes:
> I’ve attached v3 of the patch. This version adds a check for NULL values 
> when comparing MCV entries, ensuring correctness in edge cases.

Um ... what edge cases would those be?  We do not put NULL into
MCV arrays.

			regards, tom lane