"Nick Ganju" <nganju(at)mixonic(dot)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