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

From: ZizhuanLiu X-MAN <44973863(at)qq(dot)com>
To: ZizhuanLiu X-MAN <44973863(at)qq(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, Damil Shahzad <shahzaddamil(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match
Date: 2026-09-01 08:04:03
Message-ID: tencent_D53BCB02EA8D4667F8A2B6365AEA898A6F07@qq.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Original
>From: ZizhuanLiu X-MAN <44973863(at)qq(dot)com>
>Date: 2026-08-29 15:27
>To: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
>Cc: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, Damil Shahzad <shahzaddamil(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>Subject: Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match

Hi,
I found the accents in the earlier 01‑0‑setup.sql got converted by the editor.
This is now fixed, and all attachments are re‑supplied.

The correct content of 01‑0‑setup.sql is:
insert into t_mcv_123
select g, t.*,g::text
FROM generate_series(1, 500) g,
(values
('À'),
('à'),
('Á'),
('á'),
('Â'),
('â'),
('Ã'),
('ã'),
('Ä'),
('ä'),
('Å'),
('å')) t;

regards,
--
ZizhuanLiu (X-MAN) 
44973863(at)qq(dot)com

Attachment Content-Type Size
00-scan_mcv_performance_comparison.txt application/octet-stream 3.0 KB
01-0-list.txt application/octet-stream 209 bytes
01-0-setup.sql application/octet-stream 2.0 KB
01-1-material-off-model.sql application/octet-stream 896 bytes
01-2-material-off-test.shsh application/octet-stream 634 bytes
02-1-material-on-model.sql application/octet-stream 868 bytes
02-2-material-on-test.shsh application/octet-stream 710 bytes
stats.xlsx application/octet-stream 21.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Geier 2026-09-01 08:06:25 Re: Reducing relcache memory usage: deduping index shapes
Previous Message jian he 2026-09-01 07:43:47 Re: CREATE TABLE LIKE INCLUDING TRIGGERS