Idea: GSoC - Query Rewrite with Materialized Views

Поиск
Список
Период
Сортировка
От Eric Grinstein
Тема Idea: GSoC - Query Rewrite with Materialized Views
Дата
Msg-id CAK7uWEzzXJjsXP9UoXWHpnjjutjaJVpkja9SkZaLsNNrDJsJ6A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Idea: GSoC - Query Rewrite with Materialized Views  (Kevin Grittner <kgrittn@ymail.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: failures with tuplesort and ordered set aggregates (due to 5cefbf5a6c44)
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} 2.0