Thread: pgsql: Matview statistics depend on matview data.
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 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/a0a4601765b896079eb82a9d5cfa1f41154fcfdb Modified Files -------------- src/bin/pg_dump/pg_backup_archiver.c | 46 +++++++++++----- src/bin/pg_dump/pg_dump.c | 100 +++++++++++++++++++---------------- src/bin/pg_dump/pg_dump.h | 3 +- src/bin/pg_dump/pg_dump_sort.c | 2 +- 4 files changed, 91 insertions(+), 60 deletions(-)