Search Postgresql Archives
Efficiency of materialized views refresh in 9.3
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
: "
pgsql-general@xxxxxxxxxxxxxx
" <
pgsql-general@xxxxxxxxxxxxxx
>
Subject
: Efficiency of materialized views refresh in 9.3
From
: Joe Van Dyk <
joe@xxxxxxxxx
>
Date
: Thu, 4 Jul 2013 14:10:46 -0700
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Efficiency of materialized views refresh in 9.3
From:
Michael Paquier
Prev by Date:
Re: Cannot connect to remote postgres database
Next by Date:
Re: Efficiency of materialized views refresh in 9.3
Previous by thread:
unable to call a function
Next by thread:
Re: Efficiency of materialized views refresh in 9.3
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]