Incremental Materialized View Maintenance

Edit

Title

Topic

SQL Commands

Created

2019-06-07 05:36:18

Last modified

2022-08-01 16:49:47 (2 months ago)

Latest email

2022-09-09 11:10:32 (3 weeks ago)

Status

2022-09: Needs review

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

Authors

Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai)

Reviewers

Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua)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-09-09 11:10:32 by Yugo NAGATA <nagata at sraoss.co.jp>
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-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	vignesh 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