Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 348BC9FB285 for ; Fri, 9 Feb 2007 00:24:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 68205-02 for ; Fri, 9 Feb 2007 00:24:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C0F829FB1C4 for ; Fri, 9 Feb 2007 00:24:48 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l194Oja1014628; Thu, 8 Feb 2007 23:24:45 -0500 (EST) To: Joe cc: Alvaro Herrera , George Pavlov , pgsql-sql@postgresql.org Subject: Re: huge disparities in =/IN/BETWEEN performance In-reply-to: <1170994335.697.55.camel@pampa> References: <8C5B026B51B6854CBE88121DBF097A86815F42@ehost010-33.exch010.intermedia.net> <7377.1170986068@sss.pgh.pa.us> <8C5B026B51B6854CBE88121DBF097A86815F81@ehost010-33.exch010.intermedia.net> <20070209021414.GU24069@alvh.no-ip.org> <14273.1170993005@sss.pgh.pa.us> <1170994335.697.55.camel@pampa> Comments: In-reply-to Joe message dated "Thu, 08 Feb 2007 23:12:14 -0500" Date: Thu, 08 Feb 2007 23:24:44 -0500 Message-ID: <14627.1170995084@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/114 X-Sequence-Number: 27448 Joe writes: > Are you saying the planner is datatype-agnostic Certainly, but your other concerns don't follow from that. The issue at hand here is whether it's worth expending cycles on every query to try to detect a situation that only holds for a few. regards, tom lane