Postgres Pro
Downloads
Home   >   mailing lists

Thread: IN clause performance

IN clause performance

From
"Pg Coder"
Date:
Basic query optimization question- does Postgres process
 
   x IN (y1, y2) 
as fast as
   (x = y1 OR x = y2)
 
in a function?

IN clause performance

From
"Paul Codler"
Date:
Basic query optimization question- does Postgres process
 
   x IN (y1, y2) 
as fast as
   (x = y1 OR x = y2)
 
in a function?

Re: IN clause performance

From
Peter Wiersig
Date:
On Thu, Jul 19, 2007 at 05:52:30AM -0700, Paul Codler wrote:
>  Basic query optimization question- does Postgres process
>
>    x IN (y1, y2)
>  as fast as
>    (x = y1 OR x = y2)
>
>  in a function?

EXPLAIN indicates this.

Peter