| Lists: | pgsql-general |
|---|
| From: | "Markus Wollny" <Markus(dot)Wollny(at)computec(dot)de> |
|---|---|
| To: | "Net Virtual Mailing Lists" <mailinglists(at)net-virtual(dot)com>, "Matteo Beccati" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Can this be indexed? |
| Date: | 2004-11-08 09:33:45 |
| Message-ID: | 2266D0630E43BB4290742247C89105750670C5BD@dozer.computec.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
PostgreSQL doesn't provide pre-configured support for materialized views as such, but using some PL/pgSQL and triggers, one can easily implement any kind of materialized view as seen fit for the specific intended purpose (Snapshot, Eager, Lazy, Very Lazy).
You may find an excellent tutorial on materialized views with PostgreSQL here: http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
> -----Ursprüngliche Nachricht-----
> Von: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] Im Auftrag von
> Net Virtual Mailing Lists
> Gesendet: Samstag, 6. November 2004 16:49
> An: Matteo Beccati
> Betreff: Re: [GENERAL] Can this be indexed?
>
> I am not clear how to use a trigger for this, I will need to
> look into that....
>
> It is my understanding that Postgres does not have
> materialized views though (which I believe would solve this
> problem nicely) - am I mistaken?...
>
>
> - Greg
>