Robert Haas <[email protected]> writes:
> On Mon, Mar 29, 2010 at 12:03 PM, Greg Smith <[email protected]> wrote:
>> at the top of my list in this area for 9.1 is to track down the rumored
>> patch that exports information about the rejected plans considered and get
>> that comitted. That always seems what I want to look at for answering the
>> question "why this plan instead of what I was expecting?"
> Having looked at that patch, I am skeptical of it, but we can
> certainly take a fresh look.
The problem with this line of thought is that it imagines you can look
at worked-out alternative plans. You can't, because the planner doesn't
pursue rejected alternatives that far (and you'd not want to wait long
enough for it to do so...)
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers