Home > mailing lists

IN clause performance - Mailing list pgsql-general

From	Paul Codler
Subject	IN clause performance
Date	July 19, 2007 12:52:36
Msg-id	f658f8ff0707190552h6189fe96pa58ad6eec7ec5648@mail.gmail.com Whole thread Raw
In response to	IN clause performance ("Pg Coder" <pgcoder@gmail.com>)
Responses	Re: IN clause performance (Peter Wiersig <peter@friesenpeter.de>)
List	pgsql-general

Basic query optimization question- does Postgres process

x IN (y1, y2)

as fast as

(x = y1 OR x = y2)

in a function?

From: Richard Huxton
Date: 19 July 2007, 11:06:58
Subject: Re: Query performance strangeness..

From: Luca Ferrari
Date: 19 July 2007, 13:26:54
Subject: Re: query optimizer