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-06-23 13:27:28
Message-ID: a306fccf-b9e5-4f12-8942-5197879a73bd@tantorlabs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Rebased patch after 06e94ec (Fix missed checks for hashability of
container-type equality): the new `scalararray_mcv_hash_match()` now
calls `get_op_hash_functions_ext()` instead of
`get_op_hash_functions()`, passing `nominal_element_type` as the input
type so that container-type operators are correctly rejected when their
element type is not hashable.

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

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrei Lepikhov 2026-06-23 13:28:42 Re: Logging parallel worker draught
Previous Message Imran Zaheer 2026-06-23 13:27:10 Re: [WIP] Pipelined Recovery