| From: | ZizhuanLiu X-MAN <44973863(at)qq(dot)com> |
|---|---|
| To: | Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Damil Shahzad <shahzaddamil(at)gmail(dot)com> |
| Subject: | Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match |
| Date: | 2026-09-12 01:54:56 |
| Message-ID: | tencent_E9A9171B1FE075DABC69B72640BFD92CD309@qq.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Original
>From: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
>Date: 2026-09-11 04:20
>To: ZizhuanLiu X-MAN <44973863(at)qq(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>Cc: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Damil Shahzad <shahzaddamil(at)gmail(dot)com>
>Subject: Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match
>On 9/10/26 16:11, ZizhuanLiu X-MAN wrote:
>
>Thanks everyone for your time reviewing and for the valuable feedback.
>I agree with the overall suggestions. Attached is the v5 patch.
>LGTM, but you should apply pgindent to this.
>
>--
>Best regards,
>Ilia Evdokimov,
>Tantor Labs LLC,
>https://tantorlabs.com/
Hi, Ilia
Thanks for the reminder.
I've run pgindent on the new v6 patch. Comparing against v5, there are only formatting changes:
wrapped comments and added blank lines between variable declarations and following code.
regards,
--
ZizhuanLiu (X-MAN)
44973863(at)qq(dot)com
| Attachment | Content-Type | Size |
|---|---|---|
| v6-0001-Fix-var_eq_const-sum-selectivity-of-all-matching-.patch | application/octet-stream | 4.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2026-09-12 02:10:59 | Re: Row pattern recognition |
| Previous Message | Melanie Plageman | 2026-09-12 00:46:24 | Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) |