Re: [HACKERS] graph representation of data structures in optimizer

2009-02-26 Thread ITAGAKI Takahiro
Adriano Lange wrote: > The patch attached is an implementation for graph generation of data > structures in postgres. The file debuggraph.c is a simple library that > generate graphs in the format supported by graphviz. It's interesting, but I don't think it is suitable for a core feature. Cou

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-19 Thread Peter Eisentraut
On Thursday 19 February 2009 22:17:54 Adriano Lange wrote: > Tom Lane escreveu: > > But really I think the problem with this approach is that the > > information density is too low --- imagine what it would look like in a > > six-or-more-way join. I don't think the graphical approach is helpful >

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-19 Thread Adriano Lange
Tom Lane escreveu: But really I think the problem with this approach is that the information density is too low --- imagine what it would look like in a six-or-more-way join. I don't think the graphical approach is helpful at all here. I was thinking about the hard visualization and navigabili

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-18 Thread Adriano Lange
Robert Haas escreveu: That is pretty cool. It would help a lot to label the baserels with their names. > You might also want to move the RestrictInfo out of line so that it's easier to see where the inner and outer joinpath arrows are going. Humm. Maybe this is not easy to do in dot command

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-18 Thread Adriano Lange
Tom Lane escreveu: Gregory Stark writes: Adriano Lange writes: I've changed the debug functions of allpaths.c to make a graphviz-like output of RelOptInfo structure. However I have to say this graph you've generated is amazingly hard to decipher :) It took me a while to even figure out wha

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-18 Thread Tom Lane
Gregory Stark writes: > Adriano Lange writes: >> I've changed the debug functions of allpaths.c to make a graphviz-like output >> of RelOptInfo structure. > However I have to say this graph you've generated is amazingly hard to > decipher :) It took me a while to even figure out what information

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-18 Thread Robert Haas
On Wed, Feb 18, 2009 at 10:22 AM, Adriano Lange wrote: > Hi, > > I'm interested in data representation and debug of optimizer routines. Thus, > I've changed the debug functions of allpaths.c to make a graphviz-like > output of RelOptInfo structure. > > Any idea about this? > Is there some project

Re: [HACKERS] graph representation of data structures in optimizer

2009-02-18 Thread Gregory Stark
Adriano Lange writes: > Hi, > > I'm interested in data representation and debug of optimizer routines. Thus, > I've changed the debug functions of allpaths.c to make a graphviz-like output > of RelOptInfo structure. > > Any idea about this? > Is there some project or improvement like this? Sever