Index doesn't appear to be working.

From: "John Oakes" <john(at)networkproductions(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Index doesn't appear to be working.
Date: 2002-03-03 00:28:23
Message-ID: 001801c1c24a$56369270$cb842341@john
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have a table with a column titled 'passfail' that only contains either a P
for pass or an F for fail. The table name is 'one'. I created the index on
the table with:

CREATE INDEX one_passfail_idx ON one USING btree (passfail);

I then do:

VACUUM ANALYZE one;

Then I do an explain on this query:

SELECT * FROM one where passfail = 'P';

and it tells me:

Seq Scan on one (cost=0.00..263.02 rows=5613 width=56)

Shouldn't it tell me

Index Scan using one_passfail_idx on one?

Why isn't it using the index? This query returns about 5,600 of 10,000
records. It is faster to just do a seq scan because it returns such a high
percentage or records? Thanks, I appreciate the help!

John Oakes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Masaru Sugawara 2002-03-03 06:00:01 Re: using LIMIT only on primary table
Previous Message Dan Langille 2002-03-02 23:40:19 Re: using LIMIT only on primary table