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-15T05:08:56Z

Lists: pgsql-hackers

Attachments

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

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