Amir Zicherman wrote:
> 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 ?
In response to
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2004-08-18 02:56:52|
|Subject: Re: PGSQL 7.4.3 Compatible with 7.4.2?|
|Previous:||From: Amir Zicherman||Date: 2004-08-17 21:06:11|
|Subject: indexed column but queries still slow|