Incremental View Maintenance (IVM), take 2

Edit
ID 4337
Title Incremental View Maintenance (IVM), take 2
CI (CFBot) Summary
Stats (from CFBot) Patch version: v37, Patch count: 11, First patch: +23−11, All patches: +6624−78
Tags SQL Commands
Created 2023-05-31 18:58:07
Last modified 2026-04-03 01:48:06 (1 month ago)
Latest email 2026-05-29 14:14:17 (19 hours ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Waiting on Author
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
2023-11 (2023-11-01 – 2023-12-04): Moved to different CF
2023-09 (2023-09-01 – 2023-09-30): Moved to different CF
2023-07 (2023-07-01 – 2023-07-31): Moved to different CF
Target version
Authors Yugo Nagata (yugo.nagata)
Reviewers Alexandre Felipe (afelipe) Become reviewer
Committer
Links
Emails
Incremental View Maintenance, take 2
First at 2023-05-31 15:14:26 by Yugo NAGATA <nagata at sraoss.co.jp>
Latest at 2026-05-22 08:40:12 by Yugo Nagata <nagata at sraoss.co.jp>
Latest attachment (v34-0002-Add-relisivm-column-to-pg_class-system-catalog.patch) at 2024-07-11 04:23:57 from Yugo NAGATA <nagata at sraoss.co.jp>
    Attachment (v34-0002-Add-relisivm-column-to-pg_class-system-catalog.patch) at 2024-07-11 04:23:57 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v33-0011-Add-documentations-about-Incremental-View-Mainte.patch) at 2024-07-02 08:03:11 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v32-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2024-03-31 13:59:31 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v31-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2024-03-29 14:47:00 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v30-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2024-03-04 02:58:46 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (basedon_v29_matview_c_refactor_update_set_clause.patch) at 2023-09-01 07:42:17 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2023-08-28 07:05:30 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v29-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2023-08-28 02:52:52 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v28-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2023-05-31 15:14:26 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
Re: Incremental View Maintenance, take 2
First at 2026-02-12 18:08:26 by Alexandre Felipe <o.alexandre.felipe at gmail.com>
Latest at 2026-05-29 14:14:17 by Yugo Nagata <nagata at sraoss.co.jp>
Latest attachment (v37-0011-Add-documentations-about-Incremental-View-Mainte.patch) at 2026-05-29 14:14:17 from Yugo Nagata <nagata at sraoss.co.jp>
    Attachment (v37-0011-Add-documentations-about-Incremental-View-Mainte.patch) at 2026-05-29 14:14:17 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v36-0001-IMMV-Parser-support.patch) at 2026-02-16 21:43:09 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v36-0001-IMMV-Parser-support.patch) at 2026-02-16 16:07:02 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v35-0003-IMMV-Long-life-to-transition-tables.patch) at 2026-02-12 18:08:26 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
History
When Who What
2026-05-29 14:38:38 CFbot Patch does not need rebase anymore
2026-04-03 01:48:06 Yugo Nagata (yugo.nagata) Moved from CF PG19-Final to CF PG20-1
2026-03-27 01:22:32 CFbot Patch needs rebase
2026-02-12 18:19:45 CFbot Patch does not need rebase anymore
2026-02-12 18:09:24 Alexandre Felipe (afelipe) Attached mail thread CAE8JnxMPbVtHgApfQ2Gny-a+nbVQN+=Zm4-yhsY7EJTFWVm1nQ@mail.gmail.com
2026-02-12 17:03:16 Alexandre Felipe (afelipe) Added afelipe as reviewer
2026-02-09 03:40:12 Yugo Nagata (yugo.nagata) Moved from CF PG19-4 to CF PG19-Final
2025-12-23 06:59:48 Yugo Nagata (yugo.nagata) Moved from CF PG19-3 to CF PG19-4
2025-10-01 06:53:57 Yugo Nagata (yugo.nagata) Moved from CF PG19-2 to CF PG19-3
2025-09-05 12:20:27 CFbot Patch needs rebase
2025-09-02 17:20:25 CFbot Patch does not need rebase anymore
2025-08-06 01:26:39 Yugo Nagata (yugo.nagata) Moved from CF PG19-1 to CF PG19-2
2025-04-03 03:36:15 Yugo Nagata (yugo.nagata) Closed in commitfest 2025-03 with status: Moved to next CF
2025-02-17 16:20:45 CFbot Patch needs rebase
2025-02-03 13:00:40 Yugo Nagata (yugo.nagata) Closed in commitfest 2025-01 with status: Moved to next CF
2024-11-30 05:08:30 Kirill Reshke (reshke) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 17:06:23 Yugo Nagata (yugo.nagata) New status: Waiting on Author
2024-10-07 17:04:59 Yugo Nagata (yugo.nagata) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 06:25:52 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-09 06:23:22 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-09 06:23:18 Andrey Borodin (x4m) Changed targetversion to None
2024-03-04 03:06:01 Yugo Nagata (yugo.nagata) New status: Needs review
2024-02-01 10:51:19 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-26 14:43:52 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2023-12-04 10:11:26 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 10:00:17 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-05 18:16:54 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-04 20:44:10 David Rowley (davidrowley) Changed authors to Yugo Nagata (yugo.nagata)
2023-05-31 18:58:15 Yugo Nagata (yugo.nagata) Changed targetversion to 17
2023-05-31 18:58:07 Yugo Nagata (yugo.nagata) Attached mail thread 20230601235909.0e1572c27e59112f9d0cbe86@sraoss.co.jp
2023-05-31 18:58:07 Yugo Nagata (yugo.nagata) Created patch record
Edit