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: v8, Patch count: 2, First patch: +652−616, All patches: +6634−764
Tags DDL Performance PGConf.dev
Created 2026-04-29 06:06:25
Last modified 2026-04-29 13:26:33 (2 months ago)
Latest email 2026-06-23 11:02:41 (1 week ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version
Authors Alexandra Wang (alexandrawang)
Reviewers Tom Lane (tgl) Become reviewer Remove all reviewers
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-06-23 11:02:41 by Alexandra Wang <alexandra.wang.oss at gmail.com>
Latest attachment (v8-0001-Remove-stxkeys-from-pg_statistic_ext-unify-into-s.patch) at 2026-06-23 11:02:41 from Alexandra Wang <alexandra.wang.oss at gmail.com>
    Attachment (v8-0001-Remove-stxkeys-from-pg_statistic_ext-unify-into-s.patch) at 2026-06-23 11:02:41 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch) at 2026-05-15 15:30:31 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
    Attachment (v6-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch) at 2026-05-15 05:08:56 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
    Attachment (v5-0001-Add-join-MCV-statistics-for-selectivity-estimatio.patch) at 2026-05-14 23:13:26 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
    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-14 23:33:32 CFbot Patch does not need rebase anymore
2026-05-13 17:53:27 CFbot Patch needs rebase
2026-05-13 15:05:07 Tom Lane (tgl) Added tgl as reviewer
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