Michael Paquier wrote:
> Joe Van Dyk wrote:
>> 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
A RE
On Thu, Jul 4, 2013 at 4:22 PM, Michael Paquier
wrote:
> On Fri, Jul 5, 2013 at 6:10 AM, Joe Van Dyk 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:
>
On Fri, Jul 5, 2013 at 6:10 AM, Joe Van Dyk 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
Hi,
Is refreshing a materialized view in 9.3 basically:
delete from mat_view;
insert into mat_view select * from base_view;
Or is it more efficient? If no rows have changed, will new tuples be
written on a refresh?
Joe
