Skip site navigation (1) Skip section navigation (2)

BUG #4690: an select query is not using the index

From: "vikas" <vikas(dot)dubey(at)newgen(dot)co(dot)in>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4690: an select query is not using the index
Date: 2009-03-04 10:15:49
Message-ID: 200903041015.n24AFnhk092105@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4690
Logged by:          vikas
Email address:      vikas(dot)dubey(at)newgen(dot)co(dot)in
PostgreSQL version: PostgreSQL 7.3
Operating system:   i686-pc-linux-gnu
Description:        an select query is not using the index
Details: 

hi

there is a table PDBFolder whose one column is Parentfolderindex on which an
index 'idx_folder_parentfolderindex' is created.

when i execute the following query

Select ParentFolderIndex From PDBFolder Where ParentFolderIndex In (
Select FolderId From FolderTree Where Leaf = 1::int4 )

it takes approximately 10 minutes and when i see the query execution plan of
this query it shows sequence scan on pdbfolder(which contain 50,000 rows).
can you suggest there is any way to use index idx_folder_parentfolderindex
in above query

regards
Vikas Dubey

Responses

pgsql-bugs by date

Next:From: Guillaume SmetDate: 2009-03-04 10:42:06
Subject: Re: [BUGS] BUG #4689: Expanding the length of a VARCHAR column should not induce a table rewrite
Previous:From: Heikki LinnakangasDate: 2009-03-04 10:06:59
Subject: Re: BUG #4689: Expanding the length of a VARCHAR column should not induce a table rewrite

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group