Postgres Pro
Downloads
Home   >   mailing lists

Incremental refresh of materialized view - Patch - Mailing list pgsql-hackers

From hari.prasath
Subject Incremental refresh of materialized view - Patch
Date
Msg-id 154a391d341.1176179cb4319.144192970510819074@zohocorp.com
Whole thread Raw
Responses Re: Incremental refresh of materialized view - Patch  ("hari.prasath" <hari.prasath@zohocorp.com>)
Re: Incremental refresh of materialized view - Patch  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-hackers
Tree view
Hi all
      I am building a patch to refresh materialized view incrementally from the change set decoded by using logical decoding from WAL.
      
      As of now i can able to generate the changes that has to be updated in the materialized view but the thing was it not possible to do any DML operations on MATVIEWS. 

      Only from the concurrent refresh of matviews the DML operations are allowed.
      
      However if the same methods in matview.c OpenMatViewIncrementalMaintenance & CloseMatViewIncrementalMaintenance are mad extern its possible to do DML from the patches like i am building now.

      Is there any other way of doing DML operations on materialized views from patch.?
      
      <correct me if i am wrong>




cheers
- Harry

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: silent data loss with ext4 / all current versions
Next
From: konstantin knizhnik
Date:
Subject: Re: Academic help for Postgres