public inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Kirill Reshke <reshkekirill@gmail.com>
To: Yugo NAGATA <nagata@sraoss.co.jp>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Incremental View Maintenance, take 2
Date: Thu, 8 Aug 2024 15:03:08 +0500
Message-ID: <CALdSSPgmmVzRBZZd7XrPupBe_A7-Dmovxvqtfx5ywwHNJv+S7g@mail.gmail.com> (raw)
In-Reply-To: <20230601235909.0e1572c27e59112f9d0cbe86@sraoss.co.jp>
References: <20230601235909.0e1572c27e59112f9d0cbe86@sraoss.co.jp>
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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: reshkekirill@gmail.com, nagata@sraoss.co.jp
Subject: Re: Incremental View Maintenance, take 2
In-Reply-To: <CALdSSPgmmVzRBZZd7XrPupBe_A7-Dmovxvqtfx5ywwHNJv+S7g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox