> 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
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2003-10-22 16:27:49|
|Subject: Re: Low Insert/Update Performance|
|Previous:||From: Rhaoni Chiu Pereira||Date: 2003-10-22 16:21:37|
|Subject: Re: [PERFORM] Low Insert/Update Performance|