Indexes not used - Mailing list pgsql-novice

From D. Duccini
Subject Indexes not used
Date
Msg-id Pine.GSO.4.03.10103151358260.626-100000@ra.bpsi.net
Whole thread Raw
In response to change owner on a table  ("D. Duccini" <duccini@backpack.com>)
Responses Re: Indexes not used
List pgsql-novice
Just upgraded from 6.5.3, on solaris

and i'm noticing that indexes are not being used by default

IE:  if i have a table

          Table "radusage"
 Attribute |    Type     | Modifier
-----------+-------------+----------
 datetime  | timestamp   | not null
 account   | varchar(64) |
 usage     | integer     |
 sent      | integer     |
 recv      | integer     |
 ip        | bigint      |
 host      | bigint      |
 port      | smallint    |
Indices: idxradaccount,
         idxraddate,
         idxradoid


and index idxradaccount is

# \d idxradaccount
  Index "idxradaccount"
 Attribute |    Type
-----------+-------------
 account   | varchar(64)
btree


how come it doesn't use it if i

# explain select * from radusage where account = 'someuser';
NOTICE:  QUERY PLAN:

Seq Scan on radusage  (cost=0.00..13839.67 rows=5757 width=50)

EXPLAIN


????????????????



-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.
+1 651.645.9798 fax            Don't forget your BackPack!"
-----------------------------------------------------------------------------


pgsql-novice by date:

Previous
From: "Chuck Kimber"
Date:
Subject: RE: perl problems
Next
From: Tom Lane
Date:
Subject: Re: Indexes not used