From: Roberto Mello <rmello@cc.usu.edu>
To: Bernd von den Brincken <bvdb@asa.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: Thank you ! Re: Is there any Faster workaround ??
Date: Mon, 15 Apr 2002 09:23:29 -0600
Message-ID: <20020415152329.GA18325@cc.usu.edu> (raw)
In-Reply-To: <5.1.0.14.2.20020410122013.01cfdec0@pop.kundenserver.de>
References: <3CB346F6.1DD7CFB9@trade-india.com>
<3CB356D8.48F8F5F4@nsd.ca>
<5.1.0.14.2.20020410122013.01cfdec0@pop.kundenserver.de>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, bvdb@asa.de
Subject: Re: Thank you ! Re: Is there any Faster workaround ??
In-Reply-To: <20020415152329.GA18325@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox