IN clause performance

From: "Paul Codler" <pgcoder(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: IN clause performance
Date: 2007-07-19 12:52:30
Message-ID: f658f8ff0707190552h6189fe96pa58ad6eec7ec5648@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Basic query optimization question- does Postgres process

x IN (y1, y2)
as fast as
(x = y1 OR x = y2)

in a function?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2007-07-19 13:26:46 Re: query optimizer
Previous Message Richard Huxton 2007-07-19 11:06:42 Re: Query performance strangeness..