Add join MCV statistics for selectivity estimation

Edit
ID 6724
Title Add join MCV statistics for selectivity estimation
CI (CFBot) Summary
Stats (from CFBot) Patch version: v4, Patch count: 1, First patch: +5396−219, All patches: +5396−219
Tags DDL Performance PGConf.dev
Created 2026-04-29 06:06:25
Last modified 2026-04-29 13:26:33 (1 week ago)
Latest email 2026-05-06 12:19:05 (yesterday)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version
Authors Alexandra Wang (alexandrawang)
Reviewers Become reviewer
Committer
Links
Emails
Is there value in having optimizer stats for joins/foreignkeys?
First at 2025-12-01 20:10:25 by Corey Huinker <corey.huinker at gmail.com>
Latest at 2026-05-06 12:19:05 by Alexandra Wang <alexandra.wang.oss at gmail.com>
Latest attachment (v4-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch) at 2026-05-06 12:19:05 from Alexandra Wang <alexandra.wang.oss at gmail.com>
    Attachment (v4-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch) at 2026-05-06 12:19:05 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
    Attachment (v3-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch) at 2026-04-29 18:46:30 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
    Attachment (v2-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch) at 2026-04-29 13:08:58 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
    Attachment (v1-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch) at 2026-04-29 05:59:28 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
    Attachment (16b_nl.txt) at 2026-01-29 05:04:19 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
History
When Who What
2026-05-06 12:24:30 CFbot Patch does not need rebase anymore
2026-05-01 05:03:24 CFbot Patch needs rebase
2026-04-29 13:26:33 Alexandra Wang (alexandrawang) Attached mail thread CADkLM=cUwMftPLFq0iD6-qKRyNiRM2HZGYVp6=0noxA8GfuEtA@mail.gmail.com
2026-04-29 13:26:19 Alexandra Wang (alexandrawang) Detached mail thread CADkLM=cUwMftPLFq0iD6-qKRyNiRM2HZGYVp6=0noxA8GfuEtA@mail.gmail.com
2026-04-29 13:25:07 Alexandra Wang (alexandrawang) Attached mail thread CADkLM=cUwMftPLFq0iD6-qKRyNiRM2HZGYVp6=0noxA8GfuEtA@mail.gmail.com
2026-04-29 13:24:55 Alexandra Wang (alexandrawang) Detached mail thread CADkLM=cUwMftPLFq0iD6-qKRyNiRM2HZGYVp6=0noxA8GfuEtA@mail.gmail.com
2026-04-29 06:06:25 Alexandra Wang (alexandrawang) Attached mail thread CADkLM=cUwMftPLFq0iD6-qKRyNiRM2HZGYVp6=0noxA8GfuEtA@mail.gmail.com
2026-04-29 06:06:25 Alexandra Wang (alexandrawang) Created patch record
Edit