About index ... - Mailing list pgsql-novice

From
Subject About index ...
Date
Msg-id 200010110747.e9B7l2r38347@hub.org
Whole thread Raw
Responses Re: About index ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Hello,

First, excuse me for my english. I have 33 tables ( with millions rows ) and
for most tables i use btree index. My problem is when
i use explain directive. In fact btree index work only
with operator "=" . eg: select * from test where id = 45
EXPLAIN
Index scan using idx_id on test
an doesn't work with select * from test where id < 45.
EXPLAIN
Seq scan on test
Why ???

Thanks


pgsql-novice by date:

Previous
From: Bill Morrow
Date:
Subject: Re: Selecting weekdays from datetime
Next
From: Gerhard Kroder
Date:
Subject: mail-test, just discard