Re: Is there value in having optimizer stats for joins/foreignkeys?

Alexandra Wang <alexandra.wang.oss@gmail.com>

From: Alexandra Wang <alexandra.wang.oss@gmail.com>

To: jian he <jian.universality@gmail.com>

Cc: pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas@vondra.me>, Andrei Lepikhov <lepihov@gmail.com>, Corey Huinker <corey.huinker@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, hs@cybertec.at, Jeff Davis <pgsql@j-davis.com>

Date: 2026-05-15T15:30:31Z

Lists: pgsql-hackers

Attachments

v7-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch (application/octet-stream) patch v7-0001

Here's v7, another attempt to fix the unstable tests.

Best,
Alex

On Thu, May 14, 2026 at 10:08 PM Alexandra Wang <
alexandra.wang.oss@gmail.com> wrote:

> Attached v6. It should fix the CI failures on NetBSD/Windows by
> changing the ALTER TYPE invalidation test added in v5 from
> text->varchar(100) to integer->numeric, avoiding encoding-dependent
> width estimates.
>
> Best,
> Alex
>
>
> --
> Alexandra Wang
> EDB: https://www.enterprisedb.com
>


-- 
Alexandra Wang
EDB: https://www.enterprisedb.com