Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY

surya poondla <suryapoondla4@gmail.com>

View thread

From: surya poondla <suryapoondla4@gmail.com>

To: Rafia Sabih <rafia.pghackers@gmail.com>

Cc: Giuliano Gagliardi <gogi@gogi.tv>, pgsql-bugs@lists.postgresql.org

Date: 2026-03-02T22:45:32Z

Lists: pgsql-bugs

Attachments

0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect_bug1.patch (application/octet-stream) patch v3-0003
0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-performance_bug2.patch (application/octet-stream) patch v3-0003

Hi All,

Thank you Rafia for the suggestions.
I split both the bugs in 2 different commits, attaching the patches here.

For bug1, I added the test case for NULL values too.

For bug 2, I only changed matview.c and added no test case as the timings
are not constant.

I ran the regression tests for both the patches and all tests succeeded in
both cases.

Regards,
Surya Poondla

>