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 version: v2, Patch count: 1, First patch: +1468−70, All patches: +1468−70
Tags My First Patch SQL Commands
Created 2025-12-10 05:19:49
Last modified 2026-04-09 17:41:10 (3 days ago)
Latest email 2026-04-09 17:32:59 (3 days ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
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-04-09 17:32:59 by Adam Brusselback <adambrusselback at gmail.com>
Latest attachment (v2-0001-implement_mat_view_where.patch) at 2026-04-09 17:32:59 from Adam Brusselback <adambrusselback at gmail.com>
    Attachment (v2-0001-implement_mat_view_where.patch) at 2026-04-09 17:32:59 from Adam Brusselback <adambrusselback at gmail.com> (Patch: Yes)
    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-04-09 17:41:10 Adam Brusselback (tostino) Moved from CF PG19-Final to CF PG20-1
2026-04-09 17:36:32 CFbot Patch does not need rebase anymore
2026-03-11 00:47:26 CFbot Patch needs rebase
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