Re: [HACKERS] Coster/planner and edge cases...

2002-04-23 Thread Bruce Momjian
Tom Lane wrote: > Michael Loftis <[EMAIL PROTECTED]> writes: > > IE I'd like to have the information come back as say a notice or maybe > > as extra information for an EXPLAIN for my purposes, but unless there is > > interest, consensus on how it should be done, and a TODO item made of > > it,

Re: [HACKERS] Coster/planner and edge cases...

2002-04-21 Thread Tom Lane
Michael Loftis <[EMAIL PROTECTED]> writes: > IE I'd like to have the information come back as say a notice or maybe > as extra information for an EXPLAIN for my purposes, but unless there is > interest, consensus on how it should be done, and a TODO item made of > it, I won't be making a patch

Re: [HACKERS] Coster/planner and edge cases...

2002-04-21 Thread Michael Loftis
Tom Lane wrote: >Michael Loftis <[EMAIL PROTECTED]> writes: > >>Also I'd also like to know if there is a way to get the planner to burp >>out all the possible plans it considered before selecting a final plan >>or do I need to do a little surgery to get that done? >> > >You can define OPTIMIZ

Re: [HACKERS] Coster/planner and edge cases...

2002-04-21 Thread Tom Lane
Michael Loftis <[EMAIL PROTECTED]> writes: > Also I'd also like to know if there is a way to get the planner to burp > out all the possible plans it considered before selecting a final plan > or do I need to do a little surgery to get that done? You can define OPTIMIZER_DEBUG but the interface