Request a Demo
Home   >   mailing lists

Re: Avoid calling SetMatViewPopulatedState if possible - Mailing list pgsql-hackers

From David Geier
Subject Re: Avoid calling SetMatViewPopulatedState if possible
Date
Msg-id 4172933b-dc7c-4fce-8ea1-154cf4864511@gmail.com
Whole thread
In response to Avoid calling SetMatViewPopulatedState if possible  ("cca5507" <cca5507@qq.com>)
Responses Re: Avoid calling SetMatViewPopulatedState if possible
List pgsql-hackers
Tree view 
Hi,

On 10.04.2026 05:36, cca5507 wrote:
> During refresh matview, we call SetMatViewPopulatedState unconditionally even
> if the value doesn't change. Attach a small patch to optimize it.

Thanks for sharing this patch.

While being a simple patch, it would be good to know what actual use
cases this change improves on and by how much. Can you share a test case
and/or performance data?

--
David Geier

pgsql-hackers by date:

Previous
From: SATYANARAYANA NARLAPURAM
Date:
Subject: Re: [Bug]Vacuum full silently NULL out fast default columns
Next
From: Tom Lane
Date:
Subject: Re: Serverside SNI support in libpq