From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Tino Wildenhain" <tino(at)wildenhain(dot)de>, <jm(at)poure(dot)com> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Materialized Views in PostgreSQL |
Date: | 2005-09-12 18:00:27 |
Message-ID: | D425483C2C5C9F49B5B7A41F8944154757D0A6@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> -----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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paesold | 2005-09-12 18:37:54 | Re: Spinlocks, yet again: analysis and proposed patches |
Previous Message | Kurt Roeckx | 2005-09-12 17:28:46 | Re: -fPIC |