Incremental View Maintenance (IVM), take 2

Edit
ID 4337
Title Incremental View Maintenance (IVM), take 2
CI (CFBot) Needs rebase! Needs rebase since 17 hours. Failing since 4 months.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags SQL Commands
Created 2023-05-31 18:58:07
Last modified 2026-08-06 04:31:11 (5 hours ago)
Latest email 2026-08-02 04:39:23 (4 days ago)
Status
PG20-Drafts (2026-03-01 – 2027-02-28): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
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
Implementing Incremental View Maintenance
First at 2018-12-27 12:57:26 by Yugo Nagata <nagata at sraoss.co.jp>
Latest at 2022-10-12 07:53:45 by Michael Paquier <michael at paquier.xyz>
Latest attachment (v27-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2022-04-22 05:58:01 from Yugo NAGATA <nagata at sraoss.co.jp>
    Attachment (v27-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2022-04-22 05:58:01 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v27-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2022-04-22 02:29:39 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v26-0010-Add-documentations-about-Incremental-View-Mainte.patch) at 2022-03-14 10:12:17 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v25-0010-Add-documentations-about-Incremental-View-Mainte.patch) at 2022-02-03 16:48:06 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v24-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2021-10-29 09:16:28 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v24-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch) at 2021-09-22 19:57:30 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (IVM_patches_v24.tar.gz) at 2021-09-22 10:17:12 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_extra.tar.gz) at 2021-08-02 06:28:34 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v22g.tar.gz) at 2021-05-17 04:36:46 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v22f.tar.gz) at 2021-05-07 05:14:16 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v22e.tar.gz) at 2021-04-26 07:03:48 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v22d.tar.gz) at 2021-04-26 06:46:21 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v22c.tar.gz) at 2021-04-07 09:25:37 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v22b.tar.gz) at 2021-03-09 08:27:50 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v22a.tar.gz) at 2021-02-16 01:31:55 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v22.tar.gz) at 2021-01-22 07:59:54 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v21.tar.gz) at 2021-01-12 10:03:08 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v20.tar.gz) at 2020-12-22 12:51:36 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (imv.svg) at 2020-11-12 12:37:42 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: No)
    Attachment (IVM_patches_v19.tar.gz) at 2020-11-12 08:47:48 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (0001-incremental-view-doc-fixes.patch) at 2020-11-06 04:58:25 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (02_materialized_test_data.sql) at 2020-10-27 16:14:52 from Adam Brusselback <adambrusselback at gmail.com> (Patch: No)
    Attachment (IVM_patches_v18.tar.gz) at 2020-10-05 09:16:18 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v17.tar.gz) at 2020-08-21 08:23:20 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v16.tar.gz) at 2020-08-18 09:52:36 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_sucessfull_queries.tar.gz) at 2020-05-08 01:13:06 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v15a.tar.gz) at 2020-04-13 05:18:35 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v15.tar.gz) at 2020-04-10 14:26:58 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v14.tar.gz) at 2020-02-27 06:06:49 from Takuma Hoshiai <hoshiai at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v13.tar.gz) at 2020-02-10 04:58:54 from Yugo NAGATA <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v12.tar.gz) at 2020-02-04 01:58:02 from Takuma Hoshiai <hoshiai at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v11.tar.gz) at 2019-12-26 02:03:02 from Takuma Hoshiai <hoshiai at sraoss.co.jp> (Patch: No)
    Attachment (IVM_patches_v10.tar.gz) at 2019-12-20 05:02:32 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_v9.patch.gz) at 2019-12-02 02:05:38 from Takuma Hoshiai <hoshiai at sraoss.co.jp> (Patch: No)
    Attachment (create_materialized_view.patch) at 2019-11-28 02:26:40 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: Yes)
    Attachment (IVM_v8.patch.gz) at 2019-11-26 07:02:25 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: No)
    Attachment (IVM_v7.patch.gz) at 2019-11-22 06:29:45 from Tatsuo Ishii <ishii at sraoss.co.jp> (Patch: No)
    Attachment (WIP_immediate_IVM_v6.patch) at 2019-09-30 13:34:14 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (WIP_immediate_IVM_v5.patch) at 2019-07-31 09:08:51 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (WIP_immediate_IVM_v4.patch) at 2019-07-10 02:29:38 from Takuma Hoshiai <hoshiai at sraoss.co.jp> (Patch: Yes)
    Attachment (WIP_immediate_IVM_v3.patch) at 2019-06-28 10:56:20 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (WIP_immediate_IVM_v2.patch) at 2019-06-20 07:44:10 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (WIP_immediate_IVM.patch) at 2019-05-14 06:46:48 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)
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-08-02 04:39:23 by Yugo Nagata <nagata at sraoss.co.jp>
Latest attachment (v40-0004-Add-regression-tests-for-Incremental-View-Mainte.patch) at 2026-08-02 04:39:23 from Yugo Nagata <nagata at sraoss.co.jp>
    Attachment (v40-0004-Add-regression-tests-for-Incremental-View-Mainte.patch) at 2026-08-02 04:39:23 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: No)
    Attachment (v39-0007-Add-regression-tests-for-Incremental-View-Mainte.patch) at 2026-07-03 10:11:16 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)
    Attachment (v38-0011-Add-documentations-about-Incremental-View-Mainte.patch) at 2026-06-30 15:04:01 from Yugo Nagata <nagata at sraoss.co.jp> (Patch: Yes)
    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-08-06 04:31:11 Yugo Nagata (yugo.nagata) Moved from CF PG20-1 to CF PG20-Drafts
2026-08-05 16:15:36 CFbot Patch needs rebase
2026-06-15 08:54:34 Yugo Nagata (yugo.nagata) Attached mail thread 20181227215726.4d166b4874f8983a641123f5@sraoss.co.jp
2026-06-15 08:53:45 Yugo Nagata (yugo.nagata) New status: Needs review
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