On Sat, Nov 14, 2015 at 7:01 AM, Pradhan, Sabin <Sabin.Pradhan@xxxxxxxxx> wrote: > 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. No. Postgres offers just the possibility to refresh materialized views while taking a lock on it that allows reads to continue running on it WITH REFRESH MATERIALIZED VIEW CONCURRENTLY. A necessary condition is that a UNIQUE index needs to be created on it. > 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. This is a public mailing list. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
