Re: Postgresql Materialized views

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Postgresql Materialized views
Дата
Msg-id 937d27e10801121029n10fd242gc5a7089e8905b0dc@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgresql Materialized views  (Mark Mielke <mark@mark.mielke.cc>)
Ответы Re: Postgresql Materialized views  (Mark Mielke <mark@mark.mielke.cc>)
Re: Postgresql Materialized views  (Jean-Michel Pouré <jm@poure.com>)
Список pgsql-hackers
On 12/01/2008, Mark Mielke <mark@mark.mielke.cc> wrote:
> Jean-Michel Pouré wrote:
> > In my past development projects, I always used the concept of
> > Materialized VIEW to speed-up SELECTs over INSERTs
>
> Unless you are going to *pay* for it - you do realize that the best way
> to get it implemented, would be to open up the source code, and give it
> a try yourself?

In fairness to Jean-Michel, he has spent hundreds of hours in the past
doing just that and far more for the pgAdmin users in the community -
I'm sure we can excuse him for asking for what many do think would be
a useful feature in the hopes that someone listening might just decide
to pick it up.

In the meantime though - have you tried rolling your own materialised
views with some triggers Jean-Michel? I have good results doing that
in the past.

Regards, Dave


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Markus Schiltknecht
Дата:
Сообщение: Re: Some ideas about Vacuum
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: Declarative partitioning grammar