Search Postgresql Archives

Re: Optimizer issue -- bad query plan?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Optimizer issue -- bad query plan?
From: John R Pierce <pierce@xxxxxxxxxxxx>
Date: Thu, 05 Jun 2014 15:09:44 -0700
In-reply-to: <CAJ4CxL=XOHGFCJVjKVMEm2bhnz4Eyam3hYUFeQvSc2EPxf88sQ@mail.gmail.com>
User-agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.5.0

On 6/5/2014 2:43 PM, Moshe Jacobson wrote:

The EXPLAIN ANALYZE for this query indicates that all of the tables inthe query are being joined despite the fact that they are not neededat 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Optimizer issue -- bad query plan?
  - From: Moshe Jacobson

References:
- Optimizer issue -- bad query plan?
  - From: Moshe Jacobson

Prev by Date: Optimizer issue -- bad query plan?
Next by Date: Re: Optimizer issue -- bad query plan?
Previous by thread: Optimizer issue -- bad query plan?
Next by thread: Re: Optimizer issue -- bad query plan?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux