"IN" or "=" and "OR" - Mailing list pgsql-performance

From Vernon Wu
Subject "IN" or "=" and "OR"
Date
Msg-id XU4WIOKZYARQXVJIVS74JGWVE0KF4.3e2067c0@kimiko
Whole thread Raw
Responses Re: "IN" or "=" and "OR"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Which query statement is better in terms of preformance ?

select ... from table1 where field1 in  ('a', 'b', 'c')

select ... from table1 where field1='a' or field1='b' or field1='c'

Thanks.



pgsql-performance by date:

Previous
From: "enediel"
Date:
Subject: Fw: Fw: Fw: postgresql in cluster of servers
Next
From: Neil Conway
Date:
Subject: Re: join over 12 tables takes 3 secs to plan