Hi folks, I’ve updated this patch against 11.0, and tidied up a few loose ends.
refresh-mv-where-clause-#2.diff
Description: Binary data
d. > On 5 Nov 2018, at 18:14, John Dent <de...@qqdd.eu> wrote: > > Hi folks, > > I failed to post a patch on the thread “Delta Materialized View Refreshes?” > (Message-ID 1541368916681-0.p...@n3.nabble.com), so I figured I’d try again > and post directly this time. Hopefully this time, it’ll make it through. > Thanks for your patience. > > (Original message follows…) > > 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. > > <refresh-mv-where-clause.diff>