Skip site navigation (1) Skip section navigation (2)

indexes are not working for

From: Anshaj <anshaj(at)in2m(dot)com>
To: anshaj(at)in2m(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: indexes are not working for
Date: 2004-10-22 06:10:07
Message-ID: Pine.LNX.4.44.0410221037000.5072-100000@Unforgiven (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Dear group,

         I have a table foo
anshajdb=# \d foo
           Table ""
 Column  |       Type        | Modifiers
 snumber | numeric(18,0)     |
 test    | character varying |
    "snum_idx" btree (snumber)

when I try to do a query like
explain analyze select * from foo where snumber > 1000;

Seq Scan on foo  (cost=0.00..69.00 rows=320 width=391) (actual 
time=0.011..0.721 rows=323 loops=1)
   Filter: (snumber > 1000::numeric)
 Total runtime: 0.979 ms
(3 rows)
It do a sequence scan on table. Why it is not using the snum_idx in this 
query. Do I need to change some setting or indexes don't work on this 
types of query.

Thanks and Regards

"Normal people believe that if it ain't broke, don't
fix it. Engineers believe that if it ain't broke, it
doesn't have enough features yet."

In response to


pgsql-admin by date

Next:From: Simon RiggsDate: 2004-10-22 09:22:54
Subject: Re: replication using WAL archives
Previous:From: FransDate: 2004-10-22 05:55:25
Subject: Re: Upgrading to 7.4.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group