Re: Postgresql Materialized views - Mailing list pgsql-hackers

From Dave Page
Subject Re: Postgresql Materialized views
Date
Msg-id 937d27e10801121029n10fd242gc5a7089e8905b0dc@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql Materialized views  (Mark Mielke <mark@mark.mielke.cc>)
Responses Re: Postgresql Materialized views  (Mark Mielke <mark@mark.mielke.cc>)
Re: Postgresql Materialized views  (Jean-Michel Pouré <jm@poure.com>)
List 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 by date:

Previous
From: Markus Schiltknecht
Date:
Subject: Re: Some ideas about Vacuum
Next
From: Gavin Sherry
Date:
Subject: Re: Declarative partitioning grammar