On: PostgreSQL 17

[ellisv]

I've been waiting for "incremental view maintenance" (i.e. incremental updates for materialized views) but it looks like it's still a few years out.

[JamesSwift → ellisv]

I'm a huge fan of views to serve as the v1 solution for problems before we need to optimize our approach, and this is the main thing that serves as a blocker in those discussions. If only we were able to have v2 of the approach be an IVM-view, we could leverage them much more widely.

[whitepoplar → ellisv]

There's always the pg_ivm extension you can use in the meantime: https://github.com/sraoss/pg_ivm

[ellisv → whitepoplar]

Unfortunately we use a cloud provider to host our databases, so I can only install limited extensions.

[gregwebs → ellisv]

REFRESH CONCURRENTLY is already an incremental update of sorts although you still pay the price of running a full query.

[isoprophlex → whitepoplar]

Wow, brilliant! I never knew this existed. Going to try this out tomorrow, first thing!

[garyclarke27 → ellisv]

Agreed big disappointment that "incremental view maintenance" is taking so long to get into the core - despite several IVM extensions. For me this is by far the most important capability missing from Postgres.