Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 337B09FB208 for ; Thu, 8 Feb 2007 21:54:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 32391-04 for ; Thu, 8 Feb 2007 21:54:20 -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 2D7FD9FA317 for ; Thu, 8 Feb 2007 21:54:31 -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 l191sSmB007378; Thu, 8 Feb 2007 20:54:28 -0500 (EST) To: "George Pavlov" cc: pgsql-sql@postgresql.org Subject: Re: huge disparities in =/IN/BETWEEN performance In-reply-to: <8C5B026B51B6854CBE88121DBF097A86815F42@ehost010-33.exch010.intermedia.net> References: <8C5B026B51B6854CBE88121DBF097A86815F42@ehost010-33.exch010.intermedia.net> Comments: In-reply-to "George Pavlov" message dated "Thu, 08 Feb 2007 15:57:17 -0800" Date: Thu, 08 Feb 2007 20:54:28 -0500 Message-ID: <7377.1170986068@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/109 X-Sequence-Number: 27443 "George Pavlov" writes: > there is, admittedly, substantial complexity inside v_foo, with GROUP > BYs on user_id and various subqueries, but my basic thought is that > should not really matter... You're unlikely to get any useful comment on this when you have not shown any of those details, nor even an EXPLAIN. regards, tom lane