Re: A join that should be very fast is taking a long time - Mailing list pgsql-general

"Nick Ganju" <nganju@mixonic.com> writes:
> I am trying to do the following query:
> "select * from track_category_track c, track_datafile d where
> c.track_id='49682224EB2753AB0A262ACB00172E08' and d.track_id=c.track_id"

> This takes more than 1 second to run, even though track_id is indexed in
> both tables.

Have you vacuum analyzed lately?  What PG version is this?  What does
EXPLAIN show for the query plan?

            regards, tom lane