Home > mailing lists

IN clause performance - Mailing list pgsql-general

From	Pg Coder
Subject	IN clause performance
Date	July 18, 2007 22:43:41
Msg-id	f658f8ff0707181543r60fd3dadr68df3fba9747229c@mail.gmail.com Whole thread Raw
Responses	IN clause performance ("Paul Codler" <pgcoder@gmail.com>)
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: "Pat Maddox"
Date: 18 July 2007, 22:34:49
Subject: Re: Need help optimizing this query

From: Tatsuo Ishii
Date: 18 July 2007, 22:47:53
Subject: Re: Sylph-Searcher 1.0.0 released