Patch for Delta Materialized View Refreshes - Mailing list pgsql-hackers

From John Dent
Subject Patch for Delta Materialized View Refreshes
Date
Msg-id 8D73986A-4FE7-4445-B0CF-3BC5D1DCBCAB@QQdd.eu
Whole thread Raw
Responses Re: Patch for Delta Materialized View Refreshes  (John Dent <denty@QQdd.eu>)
List pgsql-hackers
Hi folks,

I failed to post a patch on the thread “Delta Materialized View Refreshes?” (Message-ID
1541368916681-0.post@n3.nabble.com),so I figured I’d try again and post directly this time. Hopefully this time, it’ll
makeit 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
mightbe 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
hopedit 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
testviewwhere type = 'main';” — with fairly obvious semantics. 

Welcome comments on the patch or approach.

denty.


Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: partitioned tables referenced by FKs
Next
From: Alvaro Herrera
Date:
Subject: Re: Getting ERROR: could not open file "base/13164/t3_16388" withpartition table with ON COMMIT