From: | denty <denty(at)QQdd(dot)eu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Delta Materialized View Refreshes? |
Date: | 2018-11-04 22:01:56 |
Message-ID: | 1541368916681-0.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi folks,
I had a crack at this, and it was pretty simple to get something working to
play around with, and it seems like it might be useful.
I developed it against 10.1, as that's what I happened to be working with at
the time. The patch is pretty small, and I hoped it would apply cleanly
against 11. Unfortunately it doesn't, but I doubt the issues are
substantial. If there is interest in moving this forward, I'll update and
re-share.
The patch enables pretty much exactly what Jeremy suggests — something like
"refresh materialized view concurrently testview where type = 'main';" —
with fairly obvious semantics.
Welcome comments on the patch or approach.
denty.
(Seems I can't attach via the web interface, so copy/paste patch below.)
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
From | Date | Subject | |
---|---|---|---|
Next Message | legrand legrand | 2018-11-04 23:25:03 | Re: Delta Materialized View Refreshes? |
Previous Message | David Rowley | 2018-11-04 21:46:57 | Re: Ordered Partitioned Table Scans |