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 21:43:09
Message-ID: CAE8JnxNXaxqFVxne3rBTx4zRZN_nY7bZzWSqNkT69O-cehkDdw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sorry,
the previous line missed the removal of the function declared but not used.

Regards,
Alexandre

On Mon, Feb 16, 2026 at 4:07 PM Alexandre Felipe <
o(dot)alexandre(dot)felipe(at)gmail(dot)com> wrote:

> 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-0010-IMMV-regression-tests.patch application/octet-stream 2.5 KB
v36-0008-IMMV-aggregates.patch application/octet-stream 36.8 KB
v36-0006-IMMV-Update-logic.patch application/octet-stream 76.0 KB
v36-0007-IMMV-DISTINCT-support.patch application/octet-stream 24.9 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 Tom Lane 2026-02-16 21:46:36 Re: generating function default settings from pg_proc.dat
Previous Message Thomas Munro 2026-02-16 21:41:52 Re: Small improvements to substring()