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

Re: indexed column but queries still slow

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Amir Zicherman <amir(dot)zicherman(at)gmail(dot)com>
Subject: Re: indexed column but queries still slow
Date: 2004-08-17 23:28:29
Message-ID: 4122949D.7060801@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-novice
Amir Zicherman wrote:

 > hi,
 >
 > i have a btree index on col1 in table1.  The column has either values
 > 1,2,3, or 4.  4 does not appear that much in the table (only 5 times).
 >  there are about 20 million rows in the table.  when i do a "select *
 > from table1 where col1=4" it takes very long time to get back to me
 > (around 4 minutes).  why is it taking so long if i have an index on
 > it?  I also tried this with a hash index and it was still slow.

May I see the result of
explain analyze select * from table1 where col1 = 4;

and also the table definition could be usefull.

Did you run recently an analyze on your table ?


Regards
Gaetano Mendola

In response to

pgsql-novice by date

Next:From: Josh BerkusDate: 2004-08-18 02:56:52
Subject: Re: PGSQL 7.4.3 Compatible with 7.4.2?
Previous:From: Amir ZichermanDate: 2004-08-17 21:06:11
Subject: indexed column but queries still slow

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