Re: help speeding up a query in postgres 8.4.5

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: help speeding up a query in postgres 8.4.5
Date: 2011-05-11 07:09:27
Message-ID: BANLkTinc8wJx7ARuRK_eYVYUg1CqnQ3OuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Apr 5, 2011 at 1:25 PM, Maria L. Wilson
<Maria(dot)L(dot)Wilson-1(at)nasa(dot)gov> wrote:

This bit:

> left outer join INVENTORY IV on GV.GRANULE_ID = IV.GRANULE_ID, INVSENSOR
> INVS

has both an explicit and an implicit join. This can constrain join
re-ordering in the planner. Can you change it to explicit joins only
and see if that helps?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pierre C 2011-05-11 11:06:53 Re: Postgres refusing to use >1 core
Previous Message Scott Marlowe 2011-05-11 04:26:57 Re: Postgres refusing to use >1 core