Re: Add starelid, attnum to pg_stats and leverage this in pg_dump

Corey Huinker <corey.huinker@gmail.com>

View thread View on postgr.es

From: Corey Huinker <corey.huinker@gmail.com>

To: Sami Imseih <samimseih@gmail.com>

Cc: Nathan Bossart <nathandbossart@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2026-03-12T23:54:17Z

Lists: pgsql-hackers

Attachments

v6-0001-Add-test-view-pg_stats_check.patch (text/x-patch) patch v6-0001
v6-0002-Add-tableid-statid-attnum-expr_attnum-columns-to-.patch (text/x-patch) patch v6-0002
v6-0003-pg_dump-Use-tableid-in-getAttributeStats.patch (text/x-patch) patch v6-0003

> It will be good to add more commentary here to the next person adding
> a test, and mention
> that only stable values should be included in this view. what do you think?
>

I added a comment, but I don't think a test writer would be confused for
long if they did break that rule.


>
>
> +       (references <link
>
> linkend="catalog-pg-class"><structname>pg_statistic_ext</structname></link>.<structfield>stxrelid</structfield>)
>

Fixed catalog-pg-attribute and catalog-pg-statistic-ext

Commits

pg_dump: Simplify query for retrieving attribute statistics.
- 4b5ba0c4ca52 19 (unreleased) landed
Add more columns to pg_stats, pg_stats_ext, and pg_stats_ext_exprs.
- 3b88e50d6c2e 19 (unreleased) landed
Add convenience view to stats import test.
- 233bbdf031e4 19 (unreleased) landed