Postgres Pro
Downloads
Home   >   mailing lists

Re: Automatic optimization of IN clauses via INNER JOIN - Mailing list pgsql-performance

From Tom Lane
Subject Re: Automatic optimization of IN clauses via INNER JOIN
Date
Msg-id 2520.1261065435@sss.pgh.pa.us
Whole thread Raw
In response to Re: Automatic optimization of IN clauses via INNER JOIN  (Thomas Hamilton <thomashamilton76@yahoo.com>)
Responses Re: Automatic optimization of IN clauses via INNER JOIN
List pgsql-performance
Tree view 
Thomas Hamilton <thomashamilton76@yahoo.com> writes:
> But in our testing�under the same optimization and conditions INNER JOIN is significantly outperforming IN.

[ shrug... ]  You haven't provided any details, so it's impossible to
offer any useful advice.

            regards, tom lane

pgsql-performance by date:

Previous
From: Thomas Hamilton
Date:
Subject: Re: Automatic optimization of IN clauses via INNER JOIN
Next
From: Robert Haas
Date:
Subject: Re: Automatic optimization of IN clauses via INNER JOIN