Postgres Pro
Downloads
Home   >   mailing lists

Re: help speeding up a query in postgres 8.4.5 - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: help speeding up a query in postgres 8.4.5
Date
Msg-id BANLkTinc8wJx7ARuRK_eYVYUg1CqnQ3OuQ@mail.gmail.com
Whole thread Raw
In response to help speeding up a query in postgres 8.4.5  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Responses Re: help speeding up a query in postgres 8.4.5  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
On Tue, Apr 5, 2011 at 1:25 PM, Maria L. Wilson
<Maria.L.Wilson-1@nasa.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?

pgsql-performance by date:

Previous
From: "Maria L. Wilson"
Date:
Subject: Re: help speeding up a query in postgres 8.4.5
Next
From: "Pierre C"
Date:
Subject: Re: Postgres refusing to use >1 core