Postgres Pro
Downloads
Home   >   mailing lists

Re: Efficiency of materialized views refresh in 9.3 - Mailing list pgsql-general

From Joe Van Dyk
Subject Re: Efficiency of materialized views refresh in 9.3
Date
Msg-id CACfv+p+ijLBo-pvAt8ZvOephQZtXv0ekDdE4KRmueD-7dZfnkA@mail.gmail.com
Whole thread Raw
In response to Re: Efficiency of materialized views refresh in 9.3  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
On Thu, Jul 4, 2013 at 4:22 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Fri, Jul 5, 2013 at 6:10 AM, Joe Van Dyk <joe@tanga.com> wrote:
> Hi,
>
> Is refreshing a materialized view in 9.3 basically:
>
>   delete from mat_view;
>   insert into mat_view select * from base_view;
Nope. Here is some documentation:
http://www.postgresql.org/docs/devel/static/rules-materializedviews.html


I meant for how postgres handles the refresh behind the scenes, not how the user actually does a refresh.

pgsql-general by date:

Previous
From: Dennis Jenkins
Date:
Subject: Re: "soft lockup" in kernel
Next
From: Vick Khera
Date:
Subject: Re: Application locking