Re: IN clause performance

From: Peter Wiersig <peter(at)friesenpeter(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: IN clause performance
Date: 2007-07-19 15:42:33
Message-ID: 20070719154233.GC6531@london087.server4you.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kynn Jones 2007-07-19 17:33:17 Re: ISO TESTS for a Pg lexer+parser
Previous Message Greg Smith 2007-07-19 15:09:44 Re: Trying to tune postgres, how is this config?