Re: [HACKERS] Contrib: alternative MATERIALIZED VIEWs - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: [HACKERS] Contrib: alternative MATERIALIZED VIEWs
Date
Msg-id f8393aac-4b4e-319f-549f-6b5c4ca5f249@BlueTreble.com
Whole thread Raw
In response to [HACKERS] Contrib: alternative MATERIALIZED VIEWs  (Nico Williams <nico@cryptonector.com>)
Responses Re: [HACKERS] Contrib: alternative MATERIALIZED VIEWs  (Nico Williams <nico@cryptonector.com>)
List pgsql-hackers
On 1/23/17 5:38 PM, Nico Williams wrote:
> Attached is an alternative implementation of MATERIALIZED VIEWs.

Interesting. I don't see this being accepted into core because it's 
plpgsql and it depends on the user to track what criteria to use to 
apply the update. The second item is the biggest issue.

That said, I think this would be useful to some people as an extension. 
I suggest you put it on github (or equivalent) and upload it to 
http://pgxn.org.

In terms of community support, the next step is to get statement-level 
support for NEW and OLD, something I think Kevin has been working on.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)



pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Re: [HACKERS] Contrib: pqasyncnotifier.c -- a shell command clientfor LISTEN
Next
From: Jia Yu
Date:
Subject: Re: [HACKERS] IndexBuild Function call fcinfo cannot access memory