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

In response to

Browse pgsql-hackers by date

  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)