fast refresh materialized view

From: "Pradhan, Sabin" <Sabin(dot)Pradhan(at)finra(dot)org>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: fast refresh materialized view
Date: 2015-11-13 22:01:54
Message-ID: 4DA0FEF4AC081C47922BE4B6D7EEAF3C9B0859FA@KWAWNEXMBP002.corp.root.nasd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does postgres has fast refresh materialized view that supports incremental refresh. In oracle , this is achieve by materialized view log. Not sure how to implement it in postgres.

Confidentiality Notice:: This email, including attachments, may include non-public, proprietary, confidential or legally privileged information. If you are not an intended recipient or an authorized agent of an intended recipient, you are hereby notified that any dissemination, distribution or copying of the information contained in or transmitted with this e-mail is unauthorized and strictly prohibited. If you have received this email in error, please notify the sender by replying to this message and permanently delete this e-mail, its attachments, and any copies of it immediately. You should not retain, copy or use this e-mail or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Grimm 2015-11-14 06:25:54 Poor performance on 9.4.4 when matching multiple columns from left side of LATERAL join
Previous Message anj patnaik 2015-11-13 21:25:14 Re: can postgres run well on NFS mounted partitions?