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: Nathan Bossart <nathandbossart@gmail.com>

Cc: Sami Imseih <samimseih@gmail.com>, pgsql-hackers@lists.postgresql.org

Date: 2026-03-14T21:13:19Z

Lists: pgsql-hackers

Attachments

v8-0001-Add-tableid-statid-attnum-expr_attnum-columns-to-.patch (text/x-patch) patch v8-0001
v8-0002-pg_dump-Use-tableid-in-getAttributeStats.patch (text/x-patch) patch v8-0002

On Fri, Mar 13, 2026 at 4:07 PM Nathan Bossart <nathandbossart@gmail.com>
wrote:

> I committed 0001, albeit with some editorialization.  The others might need
> some rebasing, which I can help with next week if someone else doesn't beat
> me to it.
>
>
"_stable", nice name choice. Rebasing was nonzero but just barely.

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