Add support for partial incremental materialized view refresh using REFRESH ... WHERE

Edit
ID 6305
Title Add support for partial incremental materialized view refresh using REFRESH ... WHERE
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +1477−74, All patches: +1477−74
Tags My First Patch SQL Commands
Created 2025-12-10 05:19:49
Last modified 2026-02-01 00:00:09 (3 days ago)
Latest email 2026-01-15 20:50:54 (2 weeks ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
Target version 19
Authors Adam Brusselback (tostino)
Reviewers Dharin Shah (dharins0)Become reviewer
Committer
Links Wiki
Emails
[Patch] Add WHERE clause support to REFRESH MATERIALIZED VIEW
First at 2025-12-08 20:58:27 by Adam Brusselback <adambrusselback at gmail.com>
Latest at 2026-01-15 20:50:54 by Dharin Shah <dharinshah95 at gmail.com>
Latest attachment (test_include_bug.sql) at 2026-01-15 18:46:15 from Dharin Shah <dharinshah95 at gmail.com>
    Attachment (test_include_bug.sql) at 2026-01-15 18:46:15 from Dharin Shah <dharinshah95 at gmail.com> (Patch: No)
    Attachment (benchmark.zip) at 2025-12-08 20:58:27 from Adam Brusselback <adambrusselback at gmail.com> (Patch: No)
History
When Who What
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-08 14:30:29 Adam Brusselback (tostino) Changed wikilink to https://wiki.postgresql.org/wiki/Materialized_Views
2026-01-08 14:30:29 Adam Brusselback (tostino) Changed name to Add support for partial incremental materialized view refresh using REFRESH ... WHERE
2026-01-06 21:42:53 Dharin Shah (dharins0) Added dharins0 as reviewer
2025-12-10 05:39:04 Adam Brusselback (tostino) Changed topic to SQL Commands
2025-12-10 05:19:49 Adam Brusselback (tostino) Attached mail thread CAMjNa7eFzTQ5=oZMQiB2bMkez5KP4A77JC7SRjeVEkOrh7cUHw@mail.gmail.com
2025-12-10 05:19:49 Adam Brusselback (tostino) Created patch record
Edit