MIME-Version: 1.0
References: <20230601235909.0e1572c27e59112f9d0cbe86@sraoss.co.jp>
In-Reply-To: <20230601235909.0e1572c27e59112f9d0cbe86@sraoss.co.jp>
From: Kirill Reshke <reshkekirill@gmail.com>
Date: Thu, 8 Aug 2024 15:03:08 +0500
Message-ID: <CALdSSPgmmVzRBZZd7XrPupBe_A7-Dmovxvqtfx5ywwHNJv+S7g@mail.gmail.com>
Subject: Re: Incremental View Maintenance, take 2
To: Yugo NAGATA <nagata@sraoss.co.jp>
Cc: pgsql-hackers@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Archived-At: <https://www.postgresql.org/message-id/CALdSSPgmmVzRBZZd7XrPupBe_A7-Dmovxvqtfx5ywwHNJv%2BS7g%40mail.gmail.com>
Precedence: bulk

On Wed, 31 May 2023 at 20:14, Yugo NAGATA <nagata@sraoss.co.jp> wrote:
>
> 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@sraoss.co.jp>

Actually, this new MV delta-table calculation can be used to make
faster REFRESH MATERIALIZED VIEW even for non-IMMV. Specifically, we
can use our cost-based Optimizer to decide which way is cheaper:
regular query execution, or delta-table approach (if it is
applicable).

Is it worth another thread?

-- 
Best regards,
Kirill Reshke