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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to