public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jeff Davis <[email protected]>
To: Ashutosh Bapat <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: pgsql-hackers <[email protected]>
Cc: Corey Huinker <[email protected]>
Subject: Re: Statistics import and export: difference in statistics of materialized view dumped
Date: Fri, 28 Mar 2025 16:20:58 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAExHW5tB7xw=_WazvwSZ2jffi6E4JoV_H36rXSjK+jrPNe-bEA@mail.gmail.com>
References: <CAExHW5s47kmubpbbRJzSM-Zfe0Tj2O3GBagB7YAyE8rQ-V24Uw@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<CAExHW5sFRnLkBjcmX8cpUgkKk=zn0WUZJ20ZZ8XUYBgPT0qnhw@mail.gmail.com>
<CAExHW5uiRcXqXvXs7FfSndHDQsf8bxOS8k=BoC5rx6VLfHBQPg@mail.gmail.com>
<[email protected]>
<CAExHW5tB7xw=_WazvwSZ2jffi6E4JoV_H36rXSjK+jrPNe-bEA@mail.gmail.com>
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
view thread (14+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Statistics import and export: difference in statistics of materialized view dumped
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox