Postgres Pro
Downloads
Home   >   mailing lists

Efficiency of materialized views refresh in 9.3 - Mailing list pgsql-general

From Joe Van Dyk
Subject Efficiency of materialized views refresh in 9.3
Date
Msg-id CACfv+pKJc+0u=tgLTirkdFNg7ZFi1yRd=MWe30M9hTJXJ+x1Kw@mail.gmail.com
Whole thread Raw
Responses Re: Efficiency of materialized views refresh in 9.3  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Stephen Carville
Date:
Subject: Re: Cannot connect to remote postgres database
Next
From: Michael Paquier
Date:
Subject: Re: Efficiency of materialized views refresh in 9.3