| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Krithika Venkatesh <krithikavenkatesh31(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Incremental refresh - Materialized view |
| Date: | 2017-11-07 07:54:29 |
| Message-ID: | 1510041269.2845.44.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Krithika Venkatesh wrote:
> I need to implement incremental refresh of materialized view.
>
> Please let me know how to do the incremental refresh of materialized view in postgresql 9.5.9 version.
>
> Is there anything similar to materialized view log in postgresql.
There is no such feature in PostgreSQL (yet), so you'll have to
do it yourself.
The "materialized view" would then be a regular table (with read only
access), and each underlying table would have a trigger that records
changes with a timestamp to a log table.
You can then write a function that brings the "materialized view"
up to date.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rakesh Kumar | 2017-11-07 12:08:55 | Re: Incremental refresh - Materialized view |
| Previous Message | Krithika Venkatesh | 2017-11-07 07:34:20 | Re: Incremental refresh - Materialized view |