От: Frank Wiles
Тема: Re: Materialized Views
Дата: ,
Msg-id: 20060116094036.12a05a8c.frank@wiles.org
(см: обсуждение, исходный текст)
Ответ на: Materialized Views  (Michael Riess)
Ответы: Re: Materialized Views  (Michael Riess)
Список: pgsql-performance

Скрыть дерево обсуждения

Materialized Views  (Michael Riess, )
 Re: Materialized Views  (Frank Wiles, )
  Re: Materialized Views  (Michael Riess, )
 Re: Materialized Views  (<>, )

On Mon, 16 Jan 2006 15:36:53 +0100
Michael Riess <> wrote:

> Hi,
> I've been reading an interesting article which compared different
> database systems, focusing on materialized views. I was wondering how
> the postgresql developers feel about this feature ... is it planned
> to implement materialized views any time soon? They would greatly
> improve both performance and readability (and thus maintainability)
> of my code.
> In particular I'm interested in a view which materializes whenever
> queried, and is invalidated as soon as underlying data is changed.

  You can already build materialized views in PostgreSQL, but you
  end up doing the "heavy lifting" yourself with triggers. You put
  insert/update/delete triggers on the underlying tables of your
  view that "do the right thing" in your materialized view table.

  I wrote a blog entry about this recently,
  http://revsys.com/blog/archive/9, where I used a very simple
  materialized view to achieve the performance I needed. It has links
  to the relevant documentation you'll need however to build triggers
  for a more complex situation.

  Hope this helps!

   Frank Wiles <>

В списке pgsql-performance по дате сообщения:

От: "Craig A. James"
Сообщение: Re: Suspending SELECTs
От: "Qingqing Zhou"
Сообщение: Re: Use of * affect the performance