On Friday, November 13, 2015 4:02 PM, "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. There has been work toward that end, but for now the best you can do is REFRESH MATERIALIZED VIEW CONCURRENTLY. This still materializes the full view in a temp table, but essentially "diffs" that against the existing data to apply an incremental change set. The can be done concurrently with reads against the materialized view and with reads and writes against the source tables. We are probably at least two years from having what you describe. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
