Postgres Pro
Downloads
Home   >   mailing lists

Re: Delta Materialized View Refreshes? - Mailing list pgsql-hackers

From Jordan Deitch
Subject Re: Delta Materialized View Refreshes?
Date
Msg-id 1536952663.1102142.1508498976.332EBE9F@webmail.messagingengine.com
Whole thread Raw
In response to Delta Materialized View Refreshes?  (Jeremy Finzel <finzelj@gmail.com>)
Responses Re: Delta Materialized View Refreshes?
List pgsql-hackers
Tree view 
Hi Jeremy,

Could you apply something similar using triggers?
One question would be how PG would identify changes to existing rows - using the replication facilities to essentially
replicateinto the view? This would be quite tricky I reckon. Otherwise a change to the underlying table may not
propagatecorrectly to the MV. 
 


-- 
Jordan Deitch
https://id.rsa.pub/

pgsql-hackers by date:

Previous
From: Jeremy Finzel
Date:
Subject: Logical replication to partitioned subscriber
Next
From: Tom Lane
Date:
Subject: Re: Consistent segfault in complex query