Statistics Import and Export

Edit

4538

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v10, Patch count: 4, First patch: +159−108, All patches: +784−302

Topic

Performance

Created

2023-08-31 19:21:04

Last modified

2025-03-18 09:57:17 (1 week ago)

Latest email

2025-03-26 01:41:25 (2 days ago)

Status

2025-03: Needs review

2025-01: Moved to next CF

2024-11: Moved to next CF

2024-09: Moved to next CF

2024-07: Moved to next CF

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

2023-09: Moved to next CF

Target version

Authors

Corey Huinker (coreyh)

Reviewers

Bharath Rupireddy (bharathrupireddy)Become reviewer

Committer

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-03-26 01:41:25 by Corey Huinker <corey.huinker at gmail.com>
Latest attachment (v10-0002-Batching-getAttributeStats.patch) at 2025-03-26 01:41:25 from Corey Huinker <corey.huinker at gmail.com>
    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-03-18 09:57:17	vigneshwaran C (vignesh.postgres)	New status: Needs review
2025-03-14 20:35:39	CFbot	Patch does not need rebase anymore
2025-03-11 04:13:47	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
2025-03-10 13:35:45	CFbot	Patch needs rebase
2025-02-22 05:31:52	CFbot	Patch does not need rebase anymore
2025-02-21 21:31:46	CFbot	Patch needs rebase
2025-02-05 22:38:50	Corey Huinker (coreyh)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-01 19:11:04	Dmitry Dolgov (erthalion)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-05 07:26:39	Bertrand Drouvot (bertranddrouvot.pg)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 06:13:04	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-08 14:31:48	Andrey Borodin (x4m)	Changed targetversion to None
2024-04-08 07:21:25	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-08 07:21:21	Andrey Borodin (x4m)	New status: Needs review
2024-03-11 12:21:46	Bharath Rupireddy (bharathrupireddy)	New status: Waiting on Author
2024-03-11 02:30:26	Bharath Rupireddy (bharathrupireddy)	Added bharathrupireddy as reviewer
2024-02-20 18:53:58	Corey Huinker (coreyh)	New status: Needs review
2024-02-01 17:50:26	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2024-02-01 17:50:21	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
2023-12-04 09:48:37	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 09:47:37	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-31 19:41:08	Corey Huinker (coreyh)	Changed authors to Corey Huinker (coreyh)
2023-08-31 19:21:16	Corey Huinker (coreyh)	Changed targetversion to 17
2023-08-31 19:21:04	Corey Huinker (coreyh)	Attached mail thread CADkLM=cB0rF3p_FuWRTMSV0983ihTRpsH+OCpNyiqE7Wk0vUWA@mail.gmail.com
2023-08-31 19:21:04	Corey Huinker (coreyh)	Created patch record

Edit