Add join MCV statistics for selectivity estimation

Edit
ID 6724
Title Add join MCV statistics for selectivity estimation
CI (CFBot) Needs rebase! Needs rebase since 2 hours. Failing since 2 hours.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags DDL Performance PGConf.dev
Created 2026-04-29 06:06:25
Last modified 2026-08-01 00:00:10 (1 week ago)
Latest email 2026-08-09 14:17:14 (yesterday)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
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-08-09 14:17:14 by Tomas Vondra <tomas at vondra.me>
Latest attachment (v9-0002-Unify-extended-statistics-columns-and-expressions.patch) at 2026-08-03 23:06:25 from Alexandra Wang <alexandra.wang.oss at gmail.com>
    Attachment (v9-0002-Unify-extended-statistics-columns-and-expressions.patch) at 2026-08-03 23:06:25 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: No)
    Attachment (flamegraph.svg) at 2026-07-16 09:18:56 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: No)
    Attachment (stats.sql) at 2026-07-03 11:51:37 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    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-08-11 10:32:43 CFbot Patch needs rebase
2026-08-01 00:00:10 CFbot Moved from CF PG20-1 to CF PG20-2
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