Re: [HACKERS] Idea: GSoC - Query Rewrite with Materialized Views

2015-03-03 Thread Eric Grinstein
> > I think even something that just does that in pure SQL/plpgsql would be a > big step forward, even if we wouldn't want it directly in the codebase. Something like creating a trigger under the hood each time a MV is created, that checks the changed rows on every statement against the query th

Re: [HACKERS] Idea: GSoC - Query Rewrite with Materialized Views

2015-02-26 Thread Eric Grinstein
Thank you for your answers. I would be very interested in tracking the staleness of the MV. You see, I work in a research group in database tuning, and we have implemented some solutions to take advantage of MV's and speed up queries. The query rewrite feature would be extremely desirable for us. D

Re: [HACKERS] Query Rewrite with Postgres' materialized views

2015-02-23 Thread Eric Grinstein
Thank you for your answers. I am very eager to contribute to Postgres, especially in the materialized views area. I have created a thread proposing to work on it as my Google Summer of Code pro

[HACKERS] Idea: GSoC - Query Rewrite with Materialized Views

2015-02-20 Thread Eric Grinstein
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

Re: [HACKERS] GSoC 2015 - mentors, students and admins.

2015-02-16 Thread Eric Grinstein
I would also like to participate as a student. 2015-02-16 13:28 GMT-02:00 Dmitry Dolgov <9erthali...@gmail.com>: > I would like to participate as student. > > On 10 February 2015 at 03:52, Thom Brown wrote: > >> Hi all, >> >> Google Summer of Code 2015 is approaching. I'm intending on registeri

[HACKERS] Query Rewrite with Postgres' materialized views

2015-02-16 Thread Eric Grinstein
r time, -- Eric Grinstein Computer Engineering Student PUC-Rio