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

From: Zizhuan Liu <44973863(at)qq(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Zizhuan Liu <44973863(at)qq(dot)com>
Subject: Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match
Date: 2026-08-05 10:36:11
Message-ID: 178592617169.1181.1374052989897980607.pgcf@coridan.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>That would double the function's runtime on average, without changing
>the results at all in most cases (it could only be different if the
>given operator has different semantics from the equality operator used
>while building the statistics list).

So I agree with Tom’s reasoning.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Damil Shahzad 2026-08-05 10:42:05 Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match
Previous Message ZizhuanLiu X-MAN 2026-08-05 10:31:34 Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match