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

From Enrique Sánchez
Subject Re: Extended statistics improvement: multi-column MCV missing values
Date
Msg-id CAOCkzAntraDudo=zghSecb4d7f4fnveUiXDHUYVWAAhrhE2QSg@mail.gmail.com
Whole thread
List pgsql-hackers
Hi, thank you for reviewing it.

Tue, 02 Jun 2026 at 0:18, Zsolt Parragi (<zsolt.parragi@percona.com>) wrote:
> The strongest
> case is a top-level AND condition with equality clauses for all columns

I see one issue related to that with the current patch, having the
same amount of conditions as the table doesn't mean that we have
conditions for all columns.
I've fixed this in the v2 patch attached above (also attached here for completeness). It focuses on the basic full-dimensional top-level AND equality miss
Now we construct a Bitmapset with the columns the clause covers and compare it to `stat->keys` that contains the columns covered by the MCV statistic.

Best regards,
Enrique.
Attachment

pgsql-hackers by date:

Previous
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Parallel Apply
Next
From: Jingtang Zhang
Date:
Subject: Re: Optimize CPU usage of dropping buffers during recovery