Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 354509FB21C for ; Sat, 27 Jan 2007 22:32:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 18679-03 for ; Sat, 27 Jan 2007 22:32:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smtp113.sbc.mail.mud.yahoo.com (smtp113.sbc.mail.mud.yahoo.com [68.142.198.212]) by postgresql.org (Postfix) with SMTP id 1C7EF9FB1D7 for ; Sat, 27 Jan 2007 22:32:00 -0400 (AST) Received: (qmail 23700 invoked from network); 28 Jan 2007 02:31:58 -0000 Received: from unknown (HELO mail.hyperstep.com) (ryan.holmes@sbcglobal.net@69.235.84.249 with login) by smtp113.sbc.mail.mud.yahoo.com with SMTP; 28 Jan 2007 02:31:58 -0000 X-YMail-OSG: uIvoWwUVM1nhCzX8md773_v1HL0lENGun2wkhGWz8Bel_lAHmEliAEvUsy.hvZQgVHRsIU3YwIWq9uO7w1bU207NKQXnQP4af5vZZCsGstpXMDIRJtNGlNSPiXDRlDc- Received: from [10.0.1.100] (unknown [10.0.1.100]) by mail.hyperstep.com (Postfix) with ESMTP id 40AD2175C19 for ; Sat, 27 Jan 2007 18:31:45 -0800 (PST) Mime-Version: 1.0 (Apple Message framework v752.2) In-Reply-To: <26081.1169949399@sss.pgh.pa.us> References: <24016.1169941986@sss.pgh.pa.us> <4F003DBB-34E7-4E9D-A8B3-27AA0CBD66C3@hyperstep.com> <26081.1169949399@sss.pgh.pa.us> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Ryan Holmes Subject: Re: IN operator causes sequential scan (vs. multiple OR expressions) Date: Sat, 27 Jan 2007 18:31:45 -0800 To: pgsql-performance@postgresql.org X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/391 X-Sequence-Number: 22992 On Jan 27, 2007, at 5:56 PM, Tom Lane wrote: > I've committed a fix for 8.2.2, but in the meantime maybe you could > change your varchar column to text? > > regards, tom lane Thank you for the help and the fix. We're just performance testing right now so minor data model changes are no problem. Thanks, -Ryan