Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match

Edit
ID 7075
Title Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match
CI (CFBot) Summary
Stats (from CFBot) Patch version: v6, Patch count: 1, First patch: +44−13, All patches: +44−13
Tags Bugfix Good First Review
Created 2026-07-30 11:06:48
Last modified 2026-10-01 00:00:08 (22 hours ago)
Latest email 2026-09-12 01:54:56 (2 weeks ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Ready for Committer
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
Target version
Authors Zizhuan Liu (liuzizhuan)
Reviewers Ilia Evdokimov (ilidock95), Damil Shahzad (damils) Become reviewer
Committer
Links
Emails
Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match
First at 2026-07-30 11:03:42 by ZizhuanLiu X-MAN <44973863 at qq.com>
Latest at 2026-09-12 01:54:56 by ZizhuanLiu X-MAN <44973863 at qq.com>
Latest attachment (v6-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-09-12 01:54:56 from ZizhuanLiu X-MAN <44973863 at qq.com>
    Attachment (v6-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-09-12 01:54:56 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v5-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-09-10 13:11:33 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (00-scan_mcv_performance_comparison.txt) at 2026-09-01 08:04:03 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (00-scan_mcv_performance_comparison.txt) at 2026-08-29 07:27:48 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (test-sql.txt) at 2026-08-26 15:00:54 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v4-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-08-20 06:47:08 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v3-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-08-19 06:59:16 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (match collate between column and express.xlsx) at 2026-08-06 09:00:50 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v2-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-08-06 07:25:04 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (match collate between column and express.xlsx) at 2026-08-05 10:31:34 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
    Attachment (v1-0001-Merge-MCV-match-and-sum-loops-in-var_eq_cons.patch) at 2026-08-05 07:33:14 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: No)
    Attachment (v1-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch) at 2026-07-30 11:03:42 from ZizhuanLiu X-MAN <44973863 at qq.com> (Patch: No)
History
When Who What
2026-10-01 00:00:08 CFbot Moved from CF PG20-2 to CF PG20-3
2026-09-21 13:32:32 Ilia Evdokimov (ilidock95) New status: Ready for Committer
2026-09-21 13:32:21 Ilia Evdokimov (ilidock95) Added ilidock95 as reviewer
2026-08-05 10:36:11 Zizhuan Liu (liuzizhuan) Posted comment with messageid <178592617169.1181.1374052989897980607.pgcf@coridan.postgresql.org>
2026-08-04 09:44:36 Damil Shahzad (damils) Added damils as reviewer
2026-07-30 11:06:48 Zizhuan Liu (liuzizhuan) Attached mail thread tencent_A15A9D89A86F2E4B086ABA462578B9B64307@qq.com
2026-07-30 11:06:48 Zizhuan Liu (liuzizhuan) Created patch record
Edit