| From: | Rakesh Kumar <rakeshkumar464(at)outlook(dot)com> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Incrementally refreshed materialized view |
| Date: | 2016-09-26 19:04:41 |
| Message-ID: | DM2PR05MB62271A2D555435AB96223988CCD0@DM2PR05MB622.namprd05.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Of course 9.5 is the current release so the answer is Yes, since 9.5
https://www.postgresql.org/docs/current/static/sql-creatematerializedview.html
What am I missing. I don't see any support for incremental refresh.
Just in case we are not speaking the same thing: When a MV is created for the first time on a base table, all further updates on the base table, will be handled by only applying the delta changes to the base table. That is called incremental refresh. Check how DB2 does it:
Or does " REFRESH MATERIALIZED VIEW." does it only incremental refresh.
Does PG have a concept of MV log, from where it can detect the delta changes and apply incremental changes quickly.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-09-26 19:05:00 | Re: need approval to join forums/community |
| Previous Message | Adam Brusselback | 2016-09-26 19:03:42 | Re: Incrementally refreshed materialized view |