| 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 |
| 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 |