Re: A join that should be very fast is taking a long time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nick Ganju" <nganju(at)mixonic(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: A join that should be very fast is taking a long time
Date: 2001-06-08 18:25:35
Message-ID: 10407.992024735@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Choe 2001-06-08 18:36:47 error starting postmaster
Previous Message Tom Lane 2001-06-08 18:23:42 Re: inserting, index and no index - speed