Thread: Materialized Views in PostgreSQL
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. For example, Web CMS (or even forums) have 99% SELECT queries. Being able to use materialized view would boost speed. Kind regards, Jean-Michel
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. > Regards > Tino > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org
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