Re: Efficiency of materialized views refresh in 9.3

[Joe Van Dyk <joe@xxxxxxxxx>]

On Thu, Jul 4, 2013 at 4:22 PM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:

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