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?

Regards
Tino

Jean-Michel,

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.

We actually have some university code implementing materialized view handling
in the planner code. However, I keep not getting around to reviewing &
documenting it.

Jonathan's piece is actually an excellent article on how to implement
mattviews in user-space. Mostly, it just needs to be linked from somewhere
in the PostgreSQL.org pages.

--
Josh Berkus
Aglio Database Solutions
San Francisco

-----Original Message-----
From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-
owner@postgresql.org] On Behalf Of Tino Wildenhain
Sent: Monday, September 12, 2005 3:04 AM
To: jm@poure.com
Cc: pgsql-hackers@postgresql.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.

Dann,

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.

I was in theory working on testing and documentation. Others (better coders
than me) are welcome to take it over, though.

--
Josh Berkus
Aglio Database Solutions
San Francisco