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

From: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
To: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, David Geier <geidav(dot)pg(at)gmail(dot)com>, Chengpeng Yan <chengpeng_yan(at)outlook(dot)com>, Tatsuya Kawata <kawatatatsuya0913(at)gmail(dot)com>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Hash-based MCV matching for large IN-lists
Date: 2026-04-08 16:48:49
Message-ID: 0988b8e7-9242-4a13-9c1d-5b3ef9dd6b5d@tantorlabs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

Attachment Content-Type Size
v10-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExp.patch text/x-patch 19.4 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2026-04-08 17:00:00 Re: Add pg_stat_autovacuum_priority
Previous Message Tom Lane 2026-04-08 16:47:33 Re: Adding REPACK [concurrently]