Hash-based MCV matching for large IN-lists

Edit
ID 6356
Title Hash-based MCV matching for large IN-lists
CI (CFBot) Summary
Stats (from CFBot) Patch version: v11, Patch count: 1, First patch: +543−5, All patches: +543−5
Tags Performance
Created 2025-12-30 06:53:31
Last modified 2026-04-23 06:28:54 (2 months ago)
Latest email 2026-06-23 13:27:28 (6 hours ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Ready for Committer
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
Target version stable
Authors Ilia Evdokimov (ilidock95)
Reviewers David Geier (geidav), Tatsuya Kawata (croissant) Become reviewer
Committer
Links
Emails
Hash-based MCV matching for large IN-lists
First at 2025-12-29 20:35:43 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest at 2026-06-23 13:27:28 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest attachment (v11-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExp.patch) at 2026-06-23 13:27:28 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
    Attachment (v11-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExp.patch) at 2026-06-23 13:27:28 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v10-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExp.patch) at 2026-04-08 16:48:49 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v9-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExpr.patch) at 2026-03-20 15:58:43 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v8-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExpr.patch) at 2026-03-10 14:55:57 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v7-0003-Use-hash-based-MCV-matching-for-ScalarArrayOpExpr.patch) at 2026-03-02 09:35:15 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v6-0003-Use-hash-based-MCV-matching-for-ScalarArrayOpExpr.patch) at 2026-02-25 22:45:44 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v5-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExpr.patch) at 2026-02-18 12:48:36 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v4-0001-Use-hash-based-MCV-matching-for-ScalarArrayOpExpr.patch) at 2026-01-29 11:14:43 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (hash_mcv_in_logging.patch) at 2026-01-27 15:43:00 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v2-0001-Use-hash-based-matching-for-MCVs-in-ScalarArrayOp.patch) at 2026-01-14 10:19:36 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
    Attachment (v1-0001-Use-hash-based-matching-for-MCVs-in-ScalarArrayOp.patch) at 2025-12-29 20:35:43 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: Yes)
History
When Who What
2026-06-23 13:44:29 CFbot Patch does not need rebase anymore
2026-06-09 22:31:29 CFbot Patch needs rebase
2026-04-23 06:28:54 David Geier (geidav) New status: Ready for Committer
2026-04-08 17:10:33 CFbot Patch does not need rebase anymore
2026-04-06 09:30:43 Ilia Evdokimov (ilidock95) Moved from CF PG19-Final to CF PG20-1
2026-03-26 02:52:26 CFbot Patch needs rebase
2026-02-07 08:12:35 Tatsuya Kawata (croissant) Added croissant as reviewer
2026-02-02 08:18:22 David Geier (geidav) Added geidav as reviewer
2026-02-01 00:00:10 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-29 11:45:32 CFbot Patch does not need rebase anymore
2026-01-27 16:12:24 CFbot Patch needs rebase
2025-12-30 06:53:31 Ilia Evdokimov (ilidock95) Attached mail thread 7db341e0-fbc6-4ec5-922c-11fdafe7be12@tantorlabs.com
2025-12-30 06:53:31 Ilia Evdokimov (ilidock95) Created patch record
Edit