Re: slow select

Medora,

> I'm using pg 7.3.4 to do a select involving a join on 2 tables.
> The query is taking 15 secs which seems extreme to me considering
> the indices that exist on the two tables.  EXPLAIN ANALYZE shows
> that the indices aren't being used.  I've done VACUUM ANALYZE on the
> db with no change in results.  Shouldn't the indices be used?

No.  You're selecting 100,000 records.   For such a large record dump, a seq
scan is usually faster.

If you don't believe me, try setting enable_seqscan=false and see how long the
query takes.

--
Josh Berkus
Aglio Database Solutions
San Francisco