Re: Lack of use of indexes - Mailing list pgsql-general

Don Isgitt <djisgitt@soundenergy.com> writes:
> gds2=# explain select * from lg where section=14;
> NOTICE:  QUERY PLAN:

> Seq Scan on lg  (cost=0.00..5885.77 rows=3836 width=73)

> EXPLAIN
> gds2=# set enable_seqscan=off;
> SET VARIABLE
> gds2=# explain select * from lg where section=14;
> NOTICE:  QUERY PLAN:

> Index Scan using lgsec on lg  (cost=0.00..12167.45 rows=3836 width=73)

> EXPLAIN

Of course, the above only proves that the planner thinks the indexscan
will be slower ;-).  You should try EXPLAIN ANALYZE to see how well the
planner estimates square up with reality ...

            regards, tom lane