Re: Efficiency of materialized views refresh in 9.3

From: Joe Van Dyk <joe(at)tanga(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Efficiency of materialized views refresh in 9.3
Date: 2013-07-05 17:23:08
Message-ID: CACfv+p+ijLBo-pvAt8ZvOephQZtXv0ekDdE4KRmueD-7dZfnkA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 4, 2013 at 4:22 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com>wrote:

> On Fri, Jul 5, 2013 at 6:10 AM, Joe Van Dyk <joe(at)tanga(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2013-07-05 17:48:04 Re: Application locking
Previous Message Dennis Jenkins 2013-07-05 16:31:37 Re: "soft lockup" in kernel