index on int2. - Mailing list pgsql-sql

From Vladimir Dobrokhotov
Subject index on int2.
Date
Msg-id 01be4b49$e63ce980$9065a8c0@dvs.rybvod.kamchatka.su
Whole thread Raw
List pgsql-sql
Hello,

I create index on int2 field, and it never used:

create index xxx on ttt using btree(int2_field);
vacuum ttt; (2600 tuples)
explain select * from ttt where int2_field>1;
... Seq Scan on ttt ...

What I need to do to use index search?

Thanks.
Vladimir Dobrokhotov



pgsql-sql by date:

Previous
From: Antonio Badia
Date:
Subject: SQL parser
Next
From: Remigiusz Sokolowski
Date:
Subject: Re: [SQL] Character type name?? How to lower case it?