Re: Delta Materialized View Refreshes?

From: denty <denty(at)QQdd(dot)eu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Delta Materialized View Refreshes?
Date: 2018-09-15 08:11:12
Message-ID: 1536999072410-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The idea of allowing a WHERE clause to be appended to REFRESH MATERIALIZED
VIEW seems useful.

It would enable those that know well the pattern of data modification in
their underlying use case to schedule delta-updates (say, from crontab).

And also it would be a useful as a foundation for more ambitious ideas. For
example, some folk can/wish to do something entirely custom that is
trigger-based. Others such as Nico's have toolkits that intend to cover
quite a lot of the automagical refresh cases (see this other thread
https://www.postgresql-archive.org/Query-Rewrite-for-Materialized-Views-FDW-Extension-td6015235.html)
and it allows the data to remain in an MVIEW to boot, rather than forcing
them to use normal tables instead. It could also be the foundation for
something much more integrated such as Corey's CONTINUOUS MATERIALIZED VIEW
concept.

So I'm certainly supportive of the idea.

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2018-09-15 10:26:39 Re: when set track_commit_timestamp on, database system abort startup
Previous Message Chris Travers 2018-09-15 06:44:10 Re: Code of Conduct plan