Idea: GSoC - Query Rewrite with Materialized Views - Mailing list pgsql-hackers

From Eric Grinstein
Subject Idea: GSoC - Query Rewrite with Materialized Views
Date
Msg-id CAK7uWEzzXJjsXP9UoXWHpnjjutjaJVpkja9SkZaLsNNrDJsJ6A@mail.gmail.com
Whole thread Raw
Responses Re: Idea: GSoC - Query Rewrite with Materialized Views
List pgsql-hackers
Hello Everyone,

I'm Eric Grinstein, an Comp. Engineering undergrad at PUC-Rio, Brazil.
I'm very excited about contributing to Postgres, and thought GSoC would be 
a very good program to get me started. 

Some commercial RDBMS such as oracle implement a feature called 'Query Rewrite'
using materialized views. When a query is being processed, the system checks whether a materialized view created on a similar query could be useful for the query. If so, it rewrites it so it can take advantage of the MV, usually dispensing a lot of calculation. 

I think the implementation of the feature would be a nice project to work on, and very benefical to Postgres. Many people (including myself) miss the feature on it, and 

So, could you give me your opinion about it? If I made a proposal, would the community's response be positive? If you have things to add, new ideas, I'd be very excited to hear them.

Thank you for your time! Hope to make my first patch soon!

Eric


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: failures with tuplesort and ordered set aggregates (due to 5cefbf5a6c44)
Next
From: Heikki Linnakangas
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} 2.0