Re: Queries not using Index

Hi,

>You _have_ actually run ANALYZE on the table, right?

snet=# vacuum analyze t2002_06;
VACUUM
snet=# vacuum analyze;
VACUUM
snet=# explain analyze select * from t2002_06 WHERE station = 'SAMI4';
NOTICE:  QUERY PLAN:

Seq Scan on t2002_06  (cost=0.00..35379.69 rows=35169 width=47) (actual 
time=20.51..1717.78 rows=38146 loops=1)
Total runtime: 1730.63 msec

EXPLAIN
snet=# set enable_seqscan=off;
SET VARIABLE
snet=# explain analyze select * from t2002_06 WHERE station = 'SAMI4';
NOTICE:  QUERY PLAN:

Index Scan using t2002_06_station_idx on t2002_06  (cost=0.00..132773.85 
rows=35169 width=47) (actual time=74.86..299.53 rows=38146 loops=1)
Total runtime: 313.42 msec

EXPLAIN

Any thoughts?  I am sorry to be causing all this trouble.  I just want my 
queries to voom-voom!!  Interestingly enough, I see that the SEQ SCAN is 
now estimated at 1730.63, when I first posted to this list, it was 3900.00 
or so. Errrr

Thanks, Daryl