Re: fast refresh materialized view

On Friday, November 13, 2015 4:02 PM, "Pradhan, Sabin" <Sabin(dot)Pradhan(at)finra(dot)org> 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