Incremental Materialized View Maintenance

Edit
ID 2138
Title Incremental Materialized View Maintenance
Topic SQL Commands
Created 2019-06-07 05:36:18
Last modified 2022-10-12 07:49:45 (2 years, 2 months ago)
Latest email 2022-10-12 07:53:45 (2 years, 2 months ago)
Status
2022-09: Returned with feedback
2022-07: Moved to next CF
2022-03: Moved to next CF
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
2020-03: Moved to next CF
2020-01: Moved to next CF
2019-11: Moved to next CF
2019-09: Moved to next CF
2019-07: Moved to next CF
Target version 16
Authors Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai)
Reviewers Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua)Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2138
git checkout commitfest/cf/2138
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)
History
When Who What
2022-10-12 07:49:45 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Returned with feedback
2022-08-01 16:49:47 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-04-22 06:03:47 Yugo Nagata (yugo.nagata) New status: Needs review
2022-04-08 13:03:25 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-04-03 01:17:40 Greg Stark (stark) New status: Waiting on Author
2022-03-03 13:44:18 Justin Pryzby (justinpryzby) Changed targetversion to 16
2022-03-03 08:30:54 Yugo Nagata (yugo.nagata) Changed targetversion to None
2022-02-03 17:33:53 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-02-03 16:20:24 Yugo Nagata (yugo.nagata) New status: Needs review
2022-01-13 10:24:45 Julien Rouhaud (rjuju) New status: Waiting on Author
2021-12-03 06:49:22 Michael Paquier (michael-kun) Closed in commitfest 2021-11 with status: Moved to next CF
2021-10-04 05:00:29 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-03 02:31:29 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-02 07:29:49 Yugo Nagata (yugo.nagata) New status: Needs review
2021-07-14 15:52:45 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2021-06-17 07:29:09 yonghua jian (yonghua) Added yonghua as reviewer
2021-06-15 08:51:03 Yugo Nagata (yugo.nagata) Changed targetversion to 15
2021-04-08 15:49:18 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-04-08 15:33:51 David Steele (dsteele) Changed targetversion to None
2021-02-01 12:48:06 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2021-01-27 06:20:52 Yugo Nagata (yugo.nagata) Changed targetversion to 14
2020-12-22 13:28:33 Yugo Nagata (yugo.nagata) New status: Needs review
2020-12-01 09:54:33 Georgios Kokolatos (gkokolatos) New status: Waiting on Author
2020-12-01 09:53:44 Georgios Kokolatos (gkokolatos) Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 09:53:36 Georgios Kokolatos (gkokolatos) New status: Needs review
2020-11-23 21:26:38 Anastasia Lubennikova (lubennikovaav) New status: Waiting on Author
2020-10-28 09:13:59 Yugo Nagata (yugo.nagata) New status: Ready for Committer
2020-10-01 03:34:36 Michael Paquier (michael-kun) New status: Waiting on Author
2020-10-01 03:34:32 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-21 12:34:07 Tatsuo Ishii (ishii) New status: Ready for Committer
2020-08-03 20:46:41 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 16:14:33 David Steele (dsteele) Changed targetversion to None
2020-04-08 15:40:31 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:58:21 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2019-12-23 09:05:10 Yugo Nagata (yugo.nagata) New status: Needs review
2019-12-06 05:22:20 Toshi Harada (nuko-yokohama) Added nuko-yokohama as reviewer
2019-12-01 02:55:24 Michael Paquier (michael-kun) New status: Waiting on Author
2019-12-01 02:55:20 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-11-30 03:15:49 Tatsuo Ishii (ishii) Added ishii as reviewer
2019-11-22 07:18:39 Tatsuo Ishii (ishii) Changed authors to Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai)
2019-11-22 07:13:57 Tatsuo Ishii (ishii) Changed targetversion to 13
2019-11-22 07:10:04 Tatsuo Ishii (ishii) New status: Needs review
2019-11-07 02:00:58 Jason Altekruse (jasona) Removed jasona from reviewers
2019-11-07 02:00:35 Jason Altekruse (jasona) Added jasona as reviewer
2019-09-30 19:11:09 Álvaro Herrera (alvherre) New status: Waiting on Author
2019-09-30 19:09:35 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-30 19:08:57 Álvaro Herrera (alvherre) New status: Needs review
2019-09-12 15:19:58 Álvaro Herrera (alvherre) New status: Waiting on Author
2019-08-01 23:39:24 Thomas Munro (macdice) Closed in commitfest 2019-07 with status: Moved to next CF
2019-07-08 04:50:29 Thomas Munro (macdice) Changed name to Incremental Materialized View Maintenance
2019-06-07 05:36:45 Yugo Nagata (yugo.nagata) Changed authors to Yugo Nagata (yugo.nagata)
2019-06-07 05:36:18 Yugo Nagata (yugo.nagata) Attached mail thread 20181227215726.4d166b4874f8983a641123f5@sraoss.co.jp
2019-06-07 05:36:18 Yugo Nagata (yugo.nagata) Created patch record
Edit