Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer issue -- bad query plan? - Mailing list pgsql-general

From John R Pierce
Subject Re: Optimizer issue -- bad query plan?
Date
Msg-id 5390EAA8.5000005@hogranch.com
Whole thread Raw
In response to Optimizer issue -- bad query plan?  (Moshe Jacobson <moshe@neadwerx.com>)
Responses Re: Optimizer issue -- bad query plan?
List pgsql-general
Tree view 
On 6/5/2014 2:43 PM, Moshe Jacobson wrote:
>
> The EXPLAIN ANALYZE for this query indicates that all of the tables in
> the query are being joined despite the fact that they are not needed
> at all.
>
> Why is this?
>


why would you join 28 tables you're not using ??



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Moshe Jacobson
Date:
Subject: Optimizer issue -- bad query plan?
Next
From: Moshe Jacobson
Date:
Subject: Re: Optimizer issue -- bad query plan?