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 leaves a lot to be
desired (output to backend stdout, no way to turn it on or off except
recompile...) Also, I believe all you will see are the paths that
survived the initial pruning done by add_path. This is about the
right level of detail for examining join choices, but perhaps not very
helpful for why-didn't-it-use-my-index choices; the paths you wanted
to know about may not have got into the relation's candidate-path list
in the first place.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
