Re: Optimizer issue -- bad query plan?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizer issue -- bad query plan?
Date: 2014-06-05 22:09:44
Message-ID: 5390EAA8.5000005@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Moshe Jacobson 2014-06-05 22:35:01 Re: Optimizer issue -- bad query plan?
Previous Message Moshe Jacobson 2014-06-05 21:43:00 Optimizer issue -- bad query plan?