Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY

Title

CI (CFBot)

Needs rebase! Needs rebase since 4 days. Failing since 6 days.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Tags

Performance

Created

2026-03-12 00:41:32

Last modified

2026-03-12 00:41:32 (1 week ago)

Latest email

2026-03-21 06:19:56 (2 hours ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Needs review

Target version

Authors

Surya Poondla (spoondla)

Reviewers

Committer

Links

Emails

Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY: First at 2026-02-09 06:49:18 by Giuliano Gagliardi <gogi at gogi.tv>
Latest at 2026-03-21 06:19:56 by cca5507 <cca5507 at qq.com>
Latest attachment (v4-0001-Fix-wrong-result-of-refresh-matview-concurrently.patch) at 2026-03-13 07:20:49 from cca5507 <cca5507 at qq.com>
    Attachment (v4-0001-Fix-wrong-result-of-refresh-matview-concurrently.patch) at 2026-03-13 07:20:49 from cca5507 <cca5507 at qq.com> (Patch: Yes)
    Attachment (0003-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect_bug1.patch) at 2026-03-02 22:45:32 from surya poondla <suryapoondla4 at gmail.com> (Patch: Yes)
    Attachment (0002-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-NULL-hand.patch) at 2026-02-13 02:08:08 from surya poondla <suryapoondla4 at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-REFRESH-MATERIALIZED-VIEW-CONCURRENTLY-to-detect.patch) at 2026-02-12 00:34:25 from surya poondla <suryapoondla4 at gmail.com> (Patch: Yes)
    Attachment (0001-Check-for-duplicate-rows-with-NULLs.patch) at 2026-02-11 19:48:04 from Rafia Sabih <rafia.pghackers at gmail.com> (Patch: Yes)

History

When	Who	What
2026-03-16 20:44:24	CFbot	Patch needs rebase
2026-03-12 00:41:32	Surya Poondla (spoondla)	Attached mail thread 40d694df-39fd-4a4a-9459-9d6489165f60@gogi.tv
2026-03-12 00:41:32	Surya Poondla (spoondla)	Created patch record