iframe-proxy | Sunbelt Computer Software

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-06-15 08:54:34 (1Â weekÂ ago)

Latest email

2026-05-29 14:14:17 (3Â weeksÂ 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

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

Sunbelt Computer Software

PL/B Language Development and Support

Incremental View Maintenance (IVM), take 2

Open statuses

Closed statuses

Move to

Open statuses

Closed statuses

Move to