Re: Statistics import and export: difference in statistics of materialized view dumped - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Statistics import and export: difference in statistics of materialized view dumped
Date
Msg-id 29a2087d79080e9bbdde6d2423a94635cca639b8.camel@j-davis.com
Whole thread Raw
In response to Re: Statistics import and export: difference in statistics of materialized view dumped  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
List pgsql-hackers
On Fri, 2025-03-28 at 14:53 +0530, Ashutosh Bapat wrote:
> When I applied v1 it didn't pass.

I applied v1 on top of master as of March 15 (771ba90298), and then
took your two changes adding the tests, and it passed.

Version v2j is just rebased forward, which involved a trivial merge
conflict.

> But applying v2j-0003, the test passes.

Great.

> It feels like we can simplify this as: REFRESH MATERIALIZED VIEW
> replaces storage and resets the stats hence the Matview stats should
> be printed after printing REFRESH MATERIALIZED VIEW command in
> SECTION_POST_DATA. Also the materialized view ... . Hence the section
> may be updated later for materialized views.

Done, with a few modifications. Hopefully it's simpler.


Tom suggested that there may be other dependency problems lurking, but
I believe the patch is an improvement, so I committed it now to unblock
your work.

Regards,
    Jeff Davis




pgsql-hackers by date:

Previous
From: "Euler Taveira"
Date:
Subject: wal writer: obsolete sentence
Next
From: Masahiko Sawada
Date:
Subject: Re: On non-Windows, hard depend on uselocale(3)