Re: [HACKERS] Alternative MATERIALIZED VIEW design and implementation with history table and other features

2016-11-28 Thread Nico Williams
On Sat, Nov 26, 2016 at 04:13:19PM -0600, Jim Nasby wrote: > On 11/22/16 9:11 PM, Nico Williams wrote: > >But we needed a method for recording deltas from REFRESHes, and that's > >not supported. So I coded up my own version of materialized views, in > >PlPgSQL, that does provide a history feature.

Re: [HACKERS] Alternative MATERIALIZED VIEW design and implementation with history table and other features

2016-11-26 Thread Jim Nasby
On 11/22/16 9:11 PM, Nico Williams wrote: But we needed a method for recording deltas from REFRESHes, and that's not supported. So I coded up my own version of materialized views, in PlPgSQL, that does provide a history feature. Getting history tracking included in core is going to take a LOT

[HACKERS] Alternative MATERIALIZED VIEW design and implementation with history table and other features

2016-11-22 Thread Nico Williams
I love MATERIALIZED VIEWs. But we needed a method for recording deltas from REFRESHes, and that's not supported. So I coded up my own version of materialized views, in PlPgSQL, that does provide a history feature. Besides a history feature, this includes the ability to record changes made to a