optimizations for dumping statistics

Edit
ID 5678
Title optimizations for dumping statistics
CI (CFBot) Summary
Stats (from CFBot) Patch count: 4, First patch: +4−2, All patches: +276−64
Topic Performance
Created 2025-04-03 14:44:52
Last modified 2025-04-04 19:56:11 (2 weeks ago)
Latest email 2025-04-05 02:06:38 (2 weeks ago)
Status
2025-07: Committed
Target version 18
Authors Nathan Bossart (bossartn)
Reviewers Become reviewer
Committer Nathan Bossart (bossartn)
Links
Emails
Statistics Import and Export
First at 2023-08-31 06:47:31 by Corey Huinker <corey.huinker at gmail.com>
Latest at 2025-04-05 02:06:38 by Nathan Bossart <nathandbossart at gmail.com>
Latest attachment (v1-0001-Fall-back-to-single-attribute-stat-fetching-for-v.patch) at 2025-04-04 23:32:48 from Corey Huinker <corey.huinker at gmail.com>
    Attachment (v1-0001-Fall-back-to-single-attribute-stat-fetching-for-v.patch) at 2025-04-04 23:32:48 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v12n6-0001-Skip-second-WriteToc-call-for-custom-format-du.patch) at 2025-04-04 02:19:51 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n5-0001-Skip-second-WriteToc-for-custom-format-dumps-w.patch) at 2025-04-03 02:26:32 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n4-0001-Skip-second-WriteToc-for-custom-format-dumps-w.patch) at 2025-04-02 03:21:44 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n3-0001-Skip-second-WriteToc-for-custom-format-dumps-w.patch) at 2025-04-01 18:44:14 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n2-0001-Skip-second-WriteToc-for-custom-format-dumps-w.patch) at 2025-04-01 18:20:30 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12n-0001-Skip-second-WriteToc-for-custom-format-dumps-wi.patch) at 2025-04-01 02:33:15 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Introduce-CreateStmtPtr.patch) at 2025-03-31 15:11:47 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v11j-0001-Add-relallfrozen-to-pg_dump-statistics.patch) at 2025-03-29 05:29:16 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v11-0001-Add-relallfrozen-to-pg_dump-statistics.patch) at 2025-03-29 01:11:05 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Batching-getAttributeStats.patch) at 2025-03-26 01:41:25 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v9j-0001-Stats-use-schemaname-relname-instead-of-regclass.patch) at 2025-03-25 06:53:33 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v9-0005-Add-relallfrozen-to-pg_dump-statistics.patch) at 2025-03-16 01:37:51 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Split-relation-into-schemaname-and-relname.patch) at 2025-03-14 20:03:16 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Split-relation-into-schemaname-and-relname.patch) at 2025-03-08 07:56:18 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-pg_dump-with-X-options.patch) at 2025-03-07 01:42:30 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v6-0001-refactor-_tocEntryRequired-for-STATISTICS-DATA.patch) at 2025-03-06 04:04:29 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v5-0001-refactor-_tocEntryRequired-for-STATISTICS-DATA.patch) at 2025-03-05 08:08:55 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v2-0001-During-CREATE-INDEX-don-t-update-stats-if-autovac.patch) at 2025-02-28 20:10:37 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v2-0001-Organize-and-deduplicate-statistics-import-tests.patch) at 2025-02-28 04:34:40 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Do-not-update-stats-on-empty-table-when-building-.patch) at 2025-02-28 02:32:20 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (vTestReorg-0001-Organize-and-deduplicate-statistics-impor.patch) at 2025-02-27 02:19:12 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (vViaDellaAttnums-0001-Add-ability-to-reference-columns-by.patch) at 2025-02-26 09:25:29 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v3j-0001-Avoid-unnecessary-relation-stats-query-in-pg_dum.patch) at 2025-02-26 02:00:12 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (vAdios-Set-0001-Remove-redundant-pg_set_-_stats-variants.patch) at 2025-02-25 23:40:34 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Remove-redundant-pg_set_-_stats-variants.patch) at 2025-02-25 18:22:13 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (pg-dump-setlocale.diff) at 2025-02-24 20:20:41 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (allow-stats-att-name-or-number-wip.patch) at 2025-02-24 17:50:58 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Leverage-existing-functions-for-relation-stats.patch) at 2025-02-24 10:11:48 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v2j-0001-Avoid-unnecessary-relation-stats-query-in-pg_dum.patch) at 2025-02-24 00:21:59 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v1-0001-Leverage-existing-functions-for-relation-stats.patch) at 2025-02-22 05:00:39 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v48-0001-Enable-dumping-of-table-index-stats-in-pg_dump.patch) at 2025-02-11 19:02:21 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v47-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-02-10 03:00:18 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v46-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-02-06 09:35:28 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v45-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-02-06 04:01:13 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v43-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-01-22 03:21:51 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v42-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-01-21 19:50:33 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v41-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-01-21 06:43:17 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v40-0001-Lock-table-first-when-setting-index-relation-sta.patch) at 2025-01-21 02:25:14 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (regression.diffs) at 2025-01-20 21:26:02 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v38-0001-make-statistics-dumped-at-SECTION_POST_DATA.no-cfbot) at 2025-01-20 08:21:35 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-misc-minor-refactoring.no-cfbot) at 2025-01-18 17:00:04 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (refactor_pg_dump_onlyoption.no-cfbot) at 2025-01-17 14:20:12 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v38-0001-Enable-dumping-of-table-index-stats-in-pg_dump.patch) at 2025-01-15 20:56:04 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v37-0004-Expose-attribute-statistics-functions-for-use-in.patch) at 2025-01-07 06:18:04 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v36j-0001-Dump-table-index-stats-in-pg_dump-and-transfer-.patch) at 2024-12-20 05:23:20 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v35-0004-Add-no-schema-option-to-pg_dump-etc.patch) at 2024-12-13 05:22:38 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v34-0002-Add-no-data-option.patch) at 2024-12-12 03:49:53 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v33j-0001-Use-in-place-updates-for-pg_restore_relation_st.patch) at 2024-12-07 00:44:10 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v33-0002-Add-no-data-option.patch) at 2024-11-27 05:08:26 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v32-0003-Enable-dumping-of-table-index-stats-in-pg_dump.patch) at 2024-11-19 01:29:10 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v31-0004-Enable-in-place-updates-for-pg_restore_relation_.patch) at 2024-11-08 18:25:21 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Add-derivative-flags-dumpSchema-dumpData.patch) at 2024-11-05 02:22:28 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (0001-Add-missing-CommandCounterIncrement-in-stats-import-.patch) at 2024-10-29 01:55:00 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (pg_clear_attribute_stats_doc_v1.diff) at 2024-10-22 23:58:31 from "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (pg_set_relation_stats_patch_v1.diff) at 2024-10-22 00:50:56 from "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (v3-0001-Allow-relation_statistics_update-to-continue-afte.patch) at 2024-10-19 01:00:16 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Allow-pg_set_relation_stats-to-set-relpages-to-1.patch) at 2024-10-16 23:20:19 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Allow-pg_set_relation_stats-to-set-relpages-to-1.patch) at 2024-10-15 23:36:10 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (relpages_stat_update_v1.diff) at 2024-10-12 13:02:55 from "Shinoda, Noriyoshi (SXD Japan FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (v29-0003-Add-relkind-check-to-stats_lock_check_privileges.patch) at 2024-09-17 09:02:49 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v28-0001-minor-refactor-based-on-28j.no-cfbot) at 2024-09-08 02:02:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v28j-0001-Create-functions-pg_set_relation_stats-pg_clear.patch) at 2024-08-23 20:49:52 from Jeff Davis <pgsql at j-davis.com> (Patch: No)
    Attachment (v27j-0001-Create-function-pg_set_relation_stats.patch) at 2024-08-16 00:35:24 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v26j-0001-Create-function-pg_set_relation_stats.patch) at 2024-08-15 08:57:03 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v25j-0001-Create-function-pg_set_relation_stats.patch) at 2024-08-09 01:32:23 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v25-0001-Create-function-pg_set_relation_stats.patch) at 2024-07-28 01:08:44 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v24-0004-Add-derivative-flags-dumpSchema-dumpData.patch) at 2024-07-22 16:05:34 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Create-statistics-set-and-restore-functions.patch) at 2024-07-18 06:09:26 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-06-04 03:34:51 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-05-07 03:43:50 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-04-26 03:27:08 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-04-24 10:18:30 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-04-11 19:54:07 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-04-04 04:30:18 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Disable-updating-pg_class-for-CREATE-INDEX-durin.patch) at 2024-04-03 04:59:10 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Disable-updating-pg_class-for-CREATE-INDEX-during.patch) at 2024-04-02 09:38:53 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (stats_import_export_review.patch) at 2024-04-01 11:31:02 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-30 05:34:16 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-29 09:32:40 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (vjeff-0001-Enable-dumping-of-table-index-stats-in-pg_dump.patch) at 2024-03-29 06:25:38 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (0001-Create-pg_set_relation_stats-pg_set_attribute_stats.patch) at 2024-03-25 23:16:48 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v13-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-25 08:27:38 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-23 01:51:01 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-19 09:16:29 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch) at 2024-03-18 03:33:57 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Create-pg_set_relation_stats-pg_set_attribute_sta.patch) at 2024-03-15 07:55:13 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Create-pg_set_relation_stats-pg_set_attribute_sta.patch) at 2024-03-11 18:20:36 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Create-pg_set_relation_stats-pg_set_attribute_sta.patch) at 2024-03-08 06:35:40 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Create-pg_import_rel_stats.patch) at 2024-02-20 07:24:52 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Create-pg_import_rel_stats.patch) at 2024-02-15 09:09:41 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Create-pg_import_rel_stats.patch) at 2024-02-02 08:37:10 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Add-system-view-pg_statistic_export.patch) at 2023-12-13 10:26:04 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Additional-internal-jsonb-access-functions.patch) at 2023-10-31 07:25:17 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Introduce-the-system-view-pg_stats_export-and-the.patch) at 2023-08-31 06:47:31 from Corey Huinker <corey.huinker at gmail.com> (Patch: Yes)
History
When Who What
2025-04-04 19:56:12 Nathan Bossart (bossartn) Closed in commitfest 2025-07 with status: Committed
2025-04-03 14:45:06 Nathan Bossart (bossartn) New status: Ready for Committer
2025-04-03 14:44:56 Nathan Bossart (bossartn) Added bossartn as committer
2025-04-03 14:44:53 Nathan Bossart (bossartn) Attached mail thread CADkLM=cB0rF3p_FuWRTMSV0983ihTRpsH+OCpNyiqE7Wk0vUWA@mail.gmail.com
2025-04-03 14:44:52 Nathan Bossart (bossartn) Created patch record
Edit