Postgres Pro
Downloads
Home   >   mailing lists

Using B-Tree index for such kind of queries (with '>','<') - Mailing list pgsql-cygwin

From Andrzej Zeja
Subject Using B-Tree index for such kind of queries (with '>','<')
Date
Msg-id 002101c1f503$64ac6050$95d1a4c3@tu.kielce.pl
Whole thread Raw
List pgsql-cygwin
Tree view
Hi
 
I've got table Test and index for this table B-Tree type.
and
I've made query like:
    Select * from test where Id<100;
During execution Optimizer makes no use of the index.
In documentation stands that using B-Tree index is used for such kind of queries (with '>','<').
Everything works fine only for '=' comparision.
 
Why it doesn't work in my case?
Why Sequenced Scan is executed instead of indexed scan?
 
Below is output of my query:
template1=# explain select * from test where id > 100;
NOTICE:  QUERY PLAN:
Seq Scan on test  (cost=0.00..1.06 rows=3 width=18)
NOTICE:  QUERY PLAN:
Seq Scan on test  (cost=0.00..1.06 rows=3 width=18)
 
Andrzej

pgsql-cygwin by date:

Previous
From: Liviu Taloi
Date:
Subject: The service did not respond to the start..
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: Using B-Tree index for such kind of queries (with '