Hello

I am new to development on postgreSQL. I and my collegues are working on 
mechanisms for query rewriting, containment and view set selections and we 
have chosen postgreSQL to work with.

I found out that the debug levels and EXPLAIN command lets you know the 
selection made at each step of the query execution. I wanted to know if 
there was or there can be a way to find out what query paths are considered 
while forming the query execution plan.

PostgreSQL documentation mentions that dynamic programming is used to 
evaluate different plans and reloptinfo stores details on each 
basic/intermediate relation. So does that mean that each cell of the dp 
matrix corresponds to one reloptinfo structure.

Do give your input on these issues.

thanks

sabrina

_________________________________________________________________
Get MSN 8 Dial-up Internet Service FREE for one month.  Limited time offer-- 
sign up now!   http://join.msn.com/?page=dept/dialup


Sun, 12 Oct 2003 21:40:28 -0400
"sabrina lal" <sabrina_lal2300@hotmail.com>
None
"sabrina lal" <sabrina_lal2300@hotmail.com> writes:
> I found out that the debug levels and EXPLAIN command lets you know the 
> selection made at each step of the query execution. I wanted to know if 
> there was or there can be a way to find out what query paths are considered 
> while forming the query execution plan.

Compiling with -DOPTIMIZER_DEBUG provides some visibility into the
process, but I'd be the first to say we could use more.  Please feel
free to propose mechanisms for improving this.

			regards, tom lane

PS: please use a relevant Subject: line in future pghackers postings.

Mon, 13 Oct 2003 00:48:18 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: 