Re: Materialized Views in PostgreSQL

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)org] On Behalf Of Tino Wildenhain
> Sent: Monday, September 12, 2005 3:04 AM
> To: jm(at)poure(dot)com
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Materialized Views in PostgreSQL
>
> Jean-Michel Pouré schrieb:
> > Dear friends and all,
> >
> > Johnathan Gardner did a wonderful job on materialized views:
> > http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
> >
> > Are there any plans to integrate materialized views written in plain C
> in the
> > future. This can help gain a lot of time in Web applications.
>
> I fail to see how C would improve the situation here because you just
> send queries to the backend in those functions. You can use
> the recipes on that page just as they are. If you feel like,
> make them a contrib module you can easily apply to a situation.
>
> Not sure how an implemenation "in database" could look like.
> Maybe SQL standard reserves something for materialized views
> I dont know?

http://research.csc.ncsu.edu/selftune/

I think someone is working on merging this stuff back into the PostgreSQL core. Not sure what the current status is.

> Regards
> Tino
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org