Re: Weird query plan - Mailing list pgsql-general

From Dmitry Tkach
Subject Re: Weird query plan
Date
Msg-id 3F68C519.7050507@openratings.com
Whole thread Raw
In response to Re: Weird query plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Weird query plan
Re: Weird query plan
List pgsql-general
Tom Lane wrote:

>Dmitry Tkach <dmitry@openratings.com> writes:
>
>
>>I now have the same problem with it, but the other way around - the
>>query with a condition on a  runs quickly, and one with a condition on b
>>does not... and the query plans are the same, and have a as outer table...
>>
>>
>
>Hm.  You know, I wonder whether the query plans really are the same.
>One of the reasons why 7.3 and later show the qual conditions is that
>it was too easy to fall into the trap of assuming that plans of the same
>structure had the same conditions.  Try doing "explain verbose" and look
>to see if the plans look the same at that level of detail.
>
>            regards, tom lane
>
>
I am afraid that's too much detail for me to look at :-)
I have no clue what all that stuff means :-(

But I am pretty sure they are the same - I did not know whether the
first one or the second was supposed to be the outer relation, so I
looked at it in the debugger...
So, I know that in both cases it was using b for the outer loop...

Thanks!
Dima


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Weird query plan
Next
From: Dmitry Tkach
Date:
Subject: Re: Weird query plan