Re: Incremental View Maintenance, take 2

From: Alexandre Felipe <o(dot)alexandre(dot)felipe(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org, nagata(at)sraoss(dot)co(dot)jp, "zmlpostgres(at)gmail(dot)com" <zmlpostgres(at)gmail(dot)com>
Subject: Re: Incremental View Maintenance, take 2
Date: 2026-02-16 16:07:02
Message-ID: CAE8JnxMKmdwzwuXCt8MEztv=5zmSNgQfLnk2GREDsBFScQzNog@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

There was a warning on my initial rebase, so I fixed that.

I also changed the bitmap set to a list, I don't think we need O(1) lookup
here as suggested by Zhang [1] on patch 6.

Yugo,
I think there is an issue in
src/backend/commands/matview.c, IVM_immediate_maintenance, line 1688, when
apply_delta fails, and PG_RE_THROW is called, wouldn't we have to cleanup?
As in line 1699 onwards?

Regards,
Alexandre

On Thu, Feb 12, 2026 at 6:08 PM Alexandre Felipe <
o(dot)alexandre(dot)felipe(at)gmail(dot)com> wrote:

> Sorry for creating a new thread for this.
> I don't have the original email.
>
> This is my attempt on rebasing
> https://commitfest.postgresql.org/patch/4337/
>
> Regards,
> Alexandre
>

Attachment Content-Type Size
v36-0001-IMMV-Parser-support.patch application/octet-stream 5.1 KB
v36-0002-IMMV-relisivm-column-in-pg_class-system-catalog.patch application/octet-stream 6.1 KB
v36-0005-IMMV-support-on-psql.patch application/octet-stream 6.2 KB
v36-0003-IMMV-Long-life-to-transition-tables.patch application/octet-stream 6.0 KB
v36-0004-IMMV-pg_dump-maintanence-support.patch application/octet-stream 4.2 KB
v36-0007-IMMV-DISTINCT-support.patch application/octet-stream 24.9 KB
v36-0006-IMMV-Update-logic.patch application/octet-stream 75.9 KB
v36-0008-IMMV-aggregates.patch application/octet-stream 36.8 KB
v36-0010-IMMV-regression-tests.patch application/octet-stream 2.5 KB
v36-0009-IMMV-min-max-aggregates.patch application/octet-stream 83.3 KB
v36-0011-IMMV-documentation.patch application/octet-stream 24.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ilia Evdokimov 2026-02-16 16:16:26 Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types
Previous Message Jonathan S. Katz 2026-02-16 16:04:03 IMPORTANT: Out-of-cycle release scheduled for February 26, 2026