Re: Delta Materialized View Refreshes?

From: Jordan Deitch <jd(at)rsa(dot)pub>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: finzelj(at)gmail(dot)com
Subject: Re: Delta Materialized View Refreshes?
Date: 2018-09-14 19:17:43
Message-ID: 1536952663.1102142.1508498976.332EBE9F@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 replicate into the view? This would be quite tricky I reckon. Otherwise a change to the underlying table may not propagate correctly to the MV.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-09-14 19:55:40 Re: Consistent segfault in complex query
Previous Message Jeremy Finzel 2018-09-14 19:05:36 Logical replication to partitioned subscriber