Re: Outer joins and Seq scans - Mailing list pgsql-performance

From Tom Lane
Subject Re: Outer joins and Seq scans
Date
Msg-id 8688.1193609314@sss.pgh.pa.us
Whole thread Raw
In response to Outer joins and Seq scans  (Sami Dalouche <skoobi@free.fr>)
Responses Re: Outer joins and Seq scans  (Sami Dalouche <skoobi@free.fr>)
List pgsql-performance
Sami Dalouche <skoobi@free.fr> writes:
> So, what could prevent postgrs from using the index ?

You've carefully withheld all the details that might let us guess.
If I had to guess anyway, I'd guess this is a pre-8.2 PG release
that doesn't know how to rearrange outer joins, but there are any
number of other possibilities.

If you want useful help on a query planning issue, you generally need
to provide
    - the exact Postgres version
    - full schema declaration of the relevant tables
    - exact queries tested
    - full EXPLAIN ANALYZE output
With less info than that, people are just shooting in the dark.

            regards, tom lane

pgsql-performance by date:

Previous
From: Sami Dalouche
Date:
Subject: Outer joins and Seq scans
Next
From: Sami Dalouche
Date:
Subject: Re: Outer joins and Seq scans