Re: Queries not using Index

Hi! :)

On Wed, 24 Jul 2002, Christopher Kings-Lynne wrote:

>Have you tried playing with the statistics gatherer?

Nope.  I will look at the docs some and play around.  This machine is not 
fully production yet. :)

>Also, what is the result of:
>select indexdef from pg_indexes where indexname='t2002_06_station_idx';

snet=# select indexdef from pg_indexes where 
indexname='t2002_06_station_idx';                             indexdef                               
---------------------------------------------------------------------CREATE INDEX t2002_06_station_idx ON t2002_06
USINGbtree (station)
 


>It's no trouble.  Cases where the planner fails are essential to improving
>the planner.  Ideally this query should use your index automatically...

Thanks!  I have the ~exact~ same database on another machine with PG 7.1.2 
and it uses the Index Scan without tweaking.  I have never had troubles 
with indexes up until this table/database.

I have got another database on the same 7.2.1 machine.  It has very 
similar data and the same index.  It has no trouble defaulting to use the 
Index.

awos=# explain analyze select * from t1999_06 WHERE station = 'SAMI4';
NOTICE:  QUERY PLAN:

Index Scan using t1999_06_stn_idx on t1999_06  (cost=0.00..25859.88 
rows=36544 width=53) (actual time=152.94..152.94 rows=0 loops=1)
Total runtime: 153.03 msec

EXPLAIN

Augh.  Puzzling.  Thanks everyone for the help!  You all rock!

Daryl