Re: Unlogged materialized views

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: Adam Brusselback <adambrusselback(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Unlogged materialized views
Date: 2026-08-19 12:17:12
Message-ID: CAN4CZFNGA7DLCkYBF=mvL0qJc43a12UzUkNRGL2xE3E_+-d7zw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello!

I attached a rebased version, otherwise there are no changes.

On Tue, Aug 11, 2026 at 10:08 AM Zsolt Parragi
<zsolt(dot)parragi(at)percona(dot)com> wrote:
>
> Thanks for the feedback!
>
> > Something still has to notice and rebuild, and right now that would be on
> > every user to write themselves. It would be nice to have this built-in IMO.
>
> I agree that this would be more useful in core or in contrib, and I can implement it as part of this patch or as a follow up, but before that, I'd like some feedback if people agree with the current approach or not, as with a different approach we might need a completely different solution for that.

Attachment Content-Type Size
0003-Add-unlogged-materialized-views.patch application/octet-stream 47.1 KB
0001-Add-durable-unlogged-reset-generation-counter.patch application/octet-stream 7.1 KB
0002-Replace-pg_class.relispopulated-with-epoch-capable-r.patch application/octet-stream 25.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pierre Forstmann 2026-08-19 13:11:47 Re: [PATCH] Add planner support function to two-argument regexp_like()
Previous Message torikoshia 2026-08-19 12:14:43 Re: RFC: Allow EXPLAIN to Output Page Fault Information