| From: | Adam Brusselback <adambrusselback(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Incrementally refreshed materialized view |
| Date: | 2016-09-26 19:03:42 |
| Message-ID: | CAMjNa7dxu7kdO5Yk2Btz7BeR9WPRJJr6X=GHo--8MSzV090qGw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 26, 2016 at 2:35 PM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
> Of course 9.5 is the current release so the answer is Yes, since 9.5
>
> It seems like there is some confusion about what we're talking about. I am
talking about incremental updates to a sort of "fake" materialized view
(implemented as a table). This is totally different than what we currently
have implemented for actual materialized views (REFRESH CONCURRENTLY).
Concurrent refresh just minimizes the time the view is locked by building a
second table in the background and merging the changes between them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rakesh Kumar | 2016-09-26 19:04:41 | Re: Incrementally refreshed materialized view |
| Previous Message | Kevin Grittner | 2016-09-26 19:03:29 | Re: Incrementally refreshed materialized view |