Postgres Pro
Downloads
Home   >   mailing lists

Re: explicit joins wrong planning - Mailing list pgsql-sql

From Tom Lane
Subject Re: explicit joins wrong planning
Date
Msg-id 29784.1070047126@sss.pgh.pa.us
Whole thread Raw
In response to explicit joins wrong planning  (Tomasz Myrta <jasiek@klaster.net>)
Responses Re: explicit joins wrong planning  (Tomasz Myrta <jasiek@klaster.net>)
List pgsql-sql
Tree view 
Tomasz Myrta <jasiek@klaster.net> writes:
> Postgres doesn't use join on these both fields and doesn't use index 
> scan properly.

Hard to say much when you didn't actually show us the output of EXPLAIN
ANALYZE.
        regards, tom lane

pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: Scaler forms as function arguments
Next
From: Tomasz Myrta
Date:
Subject: Re: explicit joins wrong planning