Problem with indicies...

REGARDING Problem with indicies...

I'm having trouble getting indicies to be used when performing various
"covered" queries.

For example see the following table, index and query.

CREATE TABLE JDSFTRATT
(
ATT_CODE char(3),
DS_ID int,
FTR_ID int,
ATT_VALUE float,
ATT_TEXT varchar(128) )
;

create index jdsftratt_b_ds_id_ftr_id
on jdsftratt
using btree (ds_id int4_ops, ftr_id int4_ops, att_code char4_ops, att_value
float8_ops);

select ftr_id from jdsftratt;

As per the explain command, a "Seq Scan" (see explain command output below)
is being performed by postgres for the above query. Also, why would
sequential scan be performed by postgres given a select count(*) on and
indexed table?

explain select ftr_id from jdsftratt;

Seq Scan on jdsftratt (cost=90889.78 size=2134660 width=4)

I have verified that the index exists via querying the system tables. I'm
using postgres 6.3.2 on Sun Ultra 10 running Solaris. Any help would be
appreciated on this.

Andy