Horton

Re: Avoid calling SetMatViewPopulatedState if possible

David Geier <geidav.pg@gmail.com>

View thread
From: David Geier <geidav.pg@gmail.com>
To: cca5507 <cca5507@qq.com>, pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-05-04T18:29:47Z
Lists: pgsql-hackers 
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