Efficiency of materialized views refresh in 9.3

From: Joe Van Dyk <joe(at)tanga(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Efficiency of materialized views refresh in 9.3
Date: 2013-07-04 21:10:46
Message-ID: CACfv+pKJc+0u=tgLTirkdFNg7ZFi1yRd=MWe30M9hTJXJ+x1Kw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2013-07-04 23:22:51 Re: Efficiency of materialized views refresh in 9.3
Previous Message Stephen Carville 2013-07-04 19:53:40 Re: Cannot connect to remote postgres database