Re: [HACKERS] GSoC - code of implementation of materialized views

2010-07-08 Thread Pavel
Dne 8.7.2010 12:33, Robert Haas napsal(a): 2010/6/29 Pavel Baroš: Yeah, it is my fault, I did not mentioned that this patch is not final. It is only small part of whole implementation. I wanted to show just this, because I think that is the part that should not change much. And to show I did

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-07-08 Thread Robert Haas
On Thu, Jul 8, 2010 at 9:22 AM, Robert Haas wrote: > On Thu, Jul 8, 2010 at 9:09 AM, Pavel wrote: >> Any update on this? >> >> Sure, sorry for delay, I updated code on http://github.com/pbaros/postgres >> just a few minutes ago. Today I'll post patch here on HACKERS with my >> comments. > > It's

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-07-08 Thread Robert Haas
On Thu, Jul 8, 2010 at 9:09 AM, Pavel wrote: > Any update on this? > > Sure, sorry for delay, I updated code on http://github.com/pbaros/postgres > just a few minutes ago. Today I'll post patch here on HACKERS with my > comments. It's a little hard for me to understand what's going on via the git

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-07-08 Thread Robert Haas
2010/6/29 Pavel Baroš : > Yeah, it is my fault, I did not mentioned that this patch is not final. It > is only small part of whole implementation. I wanted to show just this, > because I think that is the part that should not change much. And to show I > did something, I am not ignoring GSoC. Now I

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-30 Thread Nicolas Barbier
2010/6/30 Robert Haas : > By the way, does the SQL standard say anything about materialized views? AFAIK, nope. Probably for the same reason that indexes are not mentioned by the standard: both are only performance enhancements, and one could easily imagine future SQL database systems that manage

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-29 Thread Robert Haas
2010/6/29 David Christensen : > Do we see supporting the creation of a materialized view from a regular view, > as in ALTER VIEW regular_view SET MATERIALIZED or some such? I'm not sure. I think we should focus our efforts on (1) getting it to work at all and then (2) improving the performance o

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-29 Thread David Christensen
On Jun 29, 2010, at 3:31 PM, Pavel Baroš wrote: > Robert Haas napsal(a): >> 2010/6/25 Pavel Baros : >> On http://github.com/pbaros/postgres can be seen changes and my attempt to implement materialized views. The first commit to the repository implements following: Mate

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-29 Thread Pavel Baroš
Robert Haas napsal(a): 2010/6/25 Pavel Baros : On http://github.com/pbaros/postgres can be seen changes and my attempt to implement materialized views. The first commit to the repository implements following: Materialized view can be created, dropped and used in SELECT statement. CREATE MAT

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-29 Thread Robert Haas
2010/6/25 Pavel Baros : >> On http://github.com/pbaros/postgres can be seen changes and my attempt to >> implement materialized views. The first commit to the repository implements >> following: >> >> Materialized view can be created, dropped and used in SELECT statement. >> >> CREATE MATERIALIZED

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-27 Thread David Fetter
On Sun, Jun 27, 2010 at 12:52:17PM +0100, Simon Riggs wrote: > On Fri, 2010-06-25 at 20:24 +0200, Pavel Baros wrote: > > > ... also you can look at enclosed patch. > > No tests == no patch This isn't quite how I'd have phrased it, and it would be nice if nobody phrased advice quite this way. :)

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-27 Thread Simon Riggs
On Fri, 2010-06-25 at 20:24 +0200, Pavel Baros wrote: > ... also you can look at enclosed patch. No tests == no patch Always best to work on the tests first, so everybody can see the syntax you are proposing, and also see if your patch actually works. Otherwise you may find people disagree and t

Re: [HACKERS] GSoC - code of implementation of materialized views

2010-06-25 Thread Pavel Baros
On http://github.com/pbaros/postgres can be seen changes and my attempt to implement materialized views. The first commit to the repository implements following: Materialized view can be created, dropped and used in SELECT statement. CREATE MATERIALIZED VIEW mvname AS SELECT ...; DROP MATERIAL

[HACKERS] GSoC - code of implementation of materialized views

2010-06-25 Thread Pavel Baros
On http://github.com/pbaros/postgres can be seen changes and my attempt to implement materialized views. The first commit to the repository implements following: Materialized view can be created, dropped and used in SELECT statement. CREATE MATERIALIZED VIEW mvname AS SELECT ...; DROP MATERIAL