Matview statistics depend on matview data.
authorJeff Davis <jdavis@postgresql.org>
Fri, 28 Mar 2025 23:12:55 +0000 (16:12 -0700)
committerJeff Davis <jdavis@postgresql.org>
Fri, 28 Mar 2025 23:12:55 +0000 (16:12 -0700)
commita0a4601765b896079eb82a9d5cfa1f41154fcfdb
tree2ad736260a4c5120f37b5bf49d20c423a2483572
parent775a06d44c04e323158826ec256386e7211e154d
Matview statistics depend on matview data.

REFRESH MATERIALIZED VIEW replaces the storage, which resets
statistics, so statistics must be restored afterward.

If both statistics and data are being dumped for a materialized view,
add a dependency from the former to the latter. Defer the statistics
to SECTION_POST_DATA, and use RESTORE_PASS_POST_ACL.

Reported-by: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Reviewed-by: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Discussion: https://postgr.es/m/CAExHW5s47kmubpbbRJzSM-Zfe0Tj2O3GBagB7YAyE8rQ-V24Uw@mail.gmail.com
src/bin/pg_dump/pg_backup_archiver.c
src/bin/pg_dump/pg_dump.c
src/bin/pg_dump/pg_dump.h
src/bin/pg_dump/pg_dump_sort.c