From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: maggon@newgen.co.in
To: pgsql-sql@postgresql.org
Subject: Re: IN Qeury Problem
Date: Thu, 17 Apr 2003 15:30:45 +0530
Message-ID: <200304171530.45076.mallah@trade-india.com> (raw)
In-Reply-To: <PIEELGOGLBEAPIHJAMIDEEMHCHAA.maggon@newgen.co.in>
References: <PIEELGOGLBEAPIHJAMIDEEMHCHAA.maggon@newgen.co.in>
Yes its a very well known problem and is
already there in the TODO. Its going to
be fixed in 7.4 release the TODO says.
you can how every rewrite your query using
EXISTS which is faster.
regds
mallah.
On Friday 18 Apr 2003 12:57 am, Sameer Maggon wrote:
> Hello,
>
> I am facing a problem regarding the performance of postgres. I am
> concerned about the speed of the execution of a query when large number of
> entries is given in the IN clause.
>
> I have a Table with columns:
>
> FolderName (Indexed)
> FolderIndex (Indexed)
> ParentFolderIndex (Indexed)
> ...
> ..
>
> I have a query where i do a SELECT
>
> SELECT * FROM FolderTable WHERE PARENTFOLDERINDEX IN (38::int8, ......);
>
> If the number of values in IN clause is small, its working fine, but as and
> when the number of values increases the speed of the query is detoriating
> with a steep curve.
>
> How can this problem be solved ?
>
> Thanks and Regards
> Sameer Maggon
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
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: mallah@trade-india.com, maggon@newgen.co.in
Subject: Re: IN Qeury Problem
In-Reply-To: <200304171530.45076.mallah@trade-india.com>
* 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