Index doesn't appear to be working. - Mailing list pgsql-general

From John Oakes
Subject Index doesn't appear to be working.
Date
Msg-id NHRf8.10874$TV4.1590523@typhoon.tampabay.rr.com
Whole thread Raw
List pgsql-general
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?  Thanks, I appreciate the help!

John Oakes









pgsql-general by date:

Previous
From: "Cornelia Boenigk"
Date:
Subject: Question to CREATE FUNCTION
Next
From: "Randy Widell"
Date:
Subject: Running under Cygwin...