Incremental View Maintenance, take 2

From: Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Incremental View Maintenance, take 2
Date: 2023-05-31 15:14:26
Message-ID: 20230601235909.0e1572c27e59112f9d0cbe86@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello hackers,

Here's a rebased version of the patch-set adding Incremental View
Maintenance support for PostgreSQL. That was discussed in [1].

The patch-set consists of the following eleven patches.

- 0001: Add a syntax to create Incrementally Maintainable Materialized Views
- 0002: Add relisivm column to pg_class system catalog
- 0003: Allow to prolong life span of transition tables until transaction end
- 0004: Add Incremental View Maintenance support to pg_dum
- 0005: Add Incremental View Maintenance support to psql
- 0006: Add Incremental View Maintenance support
- 0007: Add DISTINCT support for IVM
- 0008: Add aggregates support in IVM
- 0009: Add support for min/max aggregates for IVM
- 0010: regression tests
- 0011: documentation

[1] https://www.postgresql.org/message-id/flat/20181227215726.4d166b4874f8983a641123f5%40sraoss.co.jp

Regards,
Yugo Nagata

--
Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>

Attachment Content-Type Size
v28-0001-Add-a-syntax-to-create-Incrementally-Maintainabl.patch text/x-diff 5.0 KB
v28-0002-Add-relisivm-column-to-pg_class-system-catalog.patch text/x-diff 4.7 KB
v28-0003-Allow-to-prolong-life-span-of-transition-tables-.patch text/x-diff 6.2 KB
v28-0004-Add-Incremental-View-Maintenance-support-to-pg_d.patch text/x-diff 4.0 KB
v28-0005-Add-Incremental-View-Maintenance-support-to-psql.patch text/x-diff 4.8 KB
v28-0006-Add-Incremental-View-Maintenance-support.patch text/x-diff 75.9 KB
v28-0007-Add-DISTINCT-support-for-IVM.patch text/x-diff 23.9 KB
v28-0008-Add-aggregates-support-in-IVM.patch text/x-diff 37.8 KB
v28-0009-Add-support-for-min-max-aggregates-for-IVM.patch text/x-diff 26.4 KB
v28-0010-Add-regression-tests-for-Incremental-View-Mainte.patch text/x-diff 57.3 KB
v28-0011-Add-documentations-about-Incremental-View-Mainte.patch text/x-diff 24.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Jacobson 2023-05-31 15:40:22 Re: Do we want a hashset type?
Previous Message Tomas Vondra 2023-05-31 14:53:23 Re: Do we want a hashset type?