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

2009-02-26 Thread ITAGAKI Takahiro
Adriano Lange adri...@c3sl.ufpr.br 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

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

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 at all

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

2009-02-18 Thread Gregory Stark
Adriano Lange adri...@c3sl.ufpr.br 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

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 adri...@c3sl.ufpr.br 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

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

2009-02-18 Thread Tom Lane
Gregory Stark st...@enterprisedb.com writes: Adriano Lange adri...@c3sl.ufpr.br 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

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

2009-02-18 Thread Adriano Lange
Tom Lane escreveu: Gregory Stark st...@enterprisedb.com writes: Adriano Lange adri...@c3sl.ufpr.br 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

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