Postgres Pro
Downloads
Home   >   mailing lists

Re: IN clause performance - Mailing list pgsql-general

From Peter Wiersig
Subject Re: IN clause performance
Date
Msg-id 20070719154233.GC6531@london087.server4you.de
Whole thread Raw
In response to IN clause performance  ("Paul Codler" <pgcoder@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Trying to tune postgres, how is this config?
Next
From: "Kynn Jones"
Date:
Subject: Re: ISO TESTS for a Pg lexer+parser