Re: Hash-based MCV matching for large IN-lists

Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>

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

To: Zsolt Parragi <zsolt.parragi@percona.com>, David Geier <geidav.pg@gmail.com>, Chengpeng Yan <chengpeng_yan@outlook.com>, Tatsuya Kawata <kawatatatsuya0913@gmail.com>

Cc: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>

Date: 2026-04-08T16:48:49Z

Lists: pgsql-hackers

Attachments

v10-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExp.patch (text/x-patch) patch v10-0001

I rebased the previous patch after it was marked as "Need rebase"

I also initialized the 'elem_cost' array to all 'true' values to 
simplify the code and avoid confusion, and rewrote 
accum_scalararray_prob() to improve readability.

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

Commits

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

Short-circuit row estimation in NOT IN containing NULL consts
- c95cd2991f1e 19 (unreleased) cited