From: Sameer Maggon <maggon@newgen.co.in>
To: pgsql-sql@postgresql.org
Subject: IN Qeury Problem
Date: Thu, 17 Apr 2003 12:27:54 -0700
Message-ID: <PIEELGOGLBEAPIHJAMIDEEMHCHAA.maggon@newgen.co.in> (raw)
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
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: maggon@newgen.co.in
Subject: Re: IN Qeury Problem
In-Reply-To: <PIEELGOGLBEAPIHJAMIDEEMHCHAA.maggon@newgen.co.in>
* 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