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

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 1, First patch: +1477−74, All patches: +1477−74

Topic

SQL Commands

Tags

My First Patch

Created

2025-12-10 05:19:49

Last modified

2026-01-08 14:30:29 (1 week ago)

Latest email

2026-01-15 20:50:54 (yesterday)

Status

PG19-4 (2026-01-01 – 2026-01-31): Needs review

Target version

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-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