Re: Extended statistics improvement: multi-column MCV missing values - Mailing list pgsql-hackers

From Ilia Evdokimov
Subject Re: Extended statistics improvement: multi-column MCV missing values
Date
Msg-id 3ccc8ad1-3e84-4d2b-9556-843aded20128@tantorlabs.com
Whole thread
In response to Re: Extended statistics improvement: multi-column MCV missing values  (Enrique Sánchez <enriqueesanchz@gmail.com>)
Responses Re: Extended statistics improvement: multi-column MCV missing values
List pgsql-hackers

On 6/10/26 03:57, Enrique Sánchez wrote:

You can check v4-0002.

It's generally not safe to compare floating-point values for equality. I mean using `mcv_sel == 0.0` to detect that there are no extended MCV matches. IMO, we should use a bool variable (similar to how var_eq_const() does it) to track whether any MCV item matched, specifically in the loop where we check extended MCV matches in mcv_clauselist_selectivity(), and use that instead of checking `mcv_sel == 0.0`.

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/

pgsql-hackers by date:

Previous
From: Zsolt Parragi
Date:
Subject: Re: [PATCH v2] Add ssl_alt_cert_file/ssl_alt_key_file for dual RSA+ECDSA certificate support
Next
From: Álvaro Herrera
Date:
Subject: Re: Fix unqualified catalog references in psql describe queries