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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
