Re: Statistics import and export: difference in statistics of materialized view dumped

Jeff Davis <pgsql@j-davis.com>

View thread View on postgr.es

From: Jeff Davis <pgsql@j-davis.com>

To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgresql.org>, Corey Huinker <corey.huinker@gmail.com>

Date: 2025-03-28T05:11:06Z

Lists: pgsql-hackers

Attachments

v2j-0001-Test-pg_dump-restore-of-regression-objects.patch (text/x-patch) patch 0001
v2j-0002-Use-only-one-format-and-make-the-test-run-defaul.patch (text/x-patch) patch 0002
v2j-0003-Make-MV-statistics-depend-on-MV-data.patch (text/x-patch) patch 0003

On Thu, 2025-03-27 at 17:07 +0530, Ashutosh Bapat wrote:
> Pulled the latest sources but the test is still failing with the same
> differences.

The attached set of patches (your 0001 and 0002, combined with my patch
v2j-0003) applied on master (058b5152f0) are passing the pg_upgrade
test suite for me.

Are you saying that the tests don't work for you even when v2j-0003 is
applied? Or are you saying that your tests are failing on master, and
that v2j-0002 should be committed?

Regards,
	Jeff Davis

Commits

Matview statistics depend on matview data.
- a0a4601765b8 18.0 landed