Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (Postfix) with ESMTP id 0D313476BA3 for ; Mon, 15 Apr 2002 11:22:48 -0400 (EDT) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 16x8KH-0004rV-00; Mon, 15 Apr 2002 09:23:29 -0600 Date: Mon, 15 Apr 2002 09:23:29 -0600 From: Roberto Mello To: Bernd von den Brincken Cc: pgsql-sql@postgresql.org Subject: Re: Thank you ! Re: Is there any Faster workaround ?? Message-ID: <20020415152329.GA18325@cc.usu.edu> References: <3CB346F6.1DD7CFB9@trade-india.com> <3CB356D8.48F8F5F4@nsd.ca> <5.1.0.14.2.20020410122013.01cfdec0@pop.kundenserver.de> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <5.1.0.14.2.20020410122013.01cfdec0@pop.kundenserver.de> User-Agent: Mutt/1.3.28i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Archive-Number: 200204/187 X-Sequence-Number: 7451 On Wed, Apr 10, 2002 at 12:24:26PM +0200, Bernd von den Brincken wrote: > >> > everyone knows "IN" is pain fully slow currently in pgsql > >> > is the any fster alternative to above query > > Yes this question was posted before - and if so, and if the answer is so > simple - would it not make sense to implement this wisdom in the optimizer? The IN construct is slow in Oracle and probably other RDBMSs too. I don't know if the PostgreSQL implementation is any slower than others (I don't think it is). -Roberto -- +----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer The more things change, the more they stay the same.