Add join MCV statistics for selectivity estimation

Log in to edit
ID 6724
Title Add join MCV statistics for selectivity estimation
CI (CFBot) Summary
Stats (from CFBot) Patch version: v10, Patch count: 4, First patch: +9−7, All patches: +10454−1079
Tags DDL Performance PGConf.dev
Created 2026-04-29 06:06:25
Last modified 2026-11-18 08:50:01 (11 minutes ago)
Latest email 2026-11-18 08:44:39 (16 minutes ago)
Status
PG20-4 (2027-01-01 – 2027-01-31): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version
Authors Alexandra Wang (alexandrawang)
Reviewers Tom Lane (tgl) Log in to 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-11-18 08:44:39 by Alexandra Wang <alexandra.wang.oss at gmail.com>
Latest attachment (v10-0001-Fix-memory-leak-in-make_build_data.patch) at 2026-11-18 08:44:39 from Alexandra Wang <alexandra.wang.oss at gmail.com>
    Attachment (v10-0001-Fix-memory-leak-in-make_build_data.patch) at 2026-11-18 08:44:39 from Alexandra Wang <alexandra.wang.oss at gmail.com> (Patch: Pending check)
    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-11-18 08:53:44 CFbot Patch does not need rebase anymore
2026-11-18 08:50:01 Alexandra Wang (alexandrawang) New status: Needs review
2026-11-18 08:47:51 Alexandra Wang (alexandrawang) Moved from CF PG20-2 to CF PG20-4
2026-09-01 15:32:47 Andrey Borodin (x4m) New status: Waiting on Author
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
Log in to edit