Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] JOIN index/sequential select problem - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] JOIN index/sequential select problem
Date
Msg-id 3174.926555958@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] JOIN index/sequential select problem  (gjerde@icebox.org)
Responses Re: [SQL] JOIN index/sequential select problem
List pgsql-sql
Tree view 
gjerde@icebox.org writes:
> Then postgres is not guessing right.  Even tho the table only has 
> ~200 rows, the query still takes forever to finish.  I have let it go for
> a few minutes, and it still wasn't done..

Something wrong there; even with a nested loop, it shouldn't take more
than a few seconds to process that query.  Please dig into it a little
more (do you have gprof?) and find where it's spending the time.
        regards, tom lane

pgsql-sql by date:

Previous
From: gjerde@icebox.org
Date:
Subject: Re: [SQL] JOIN index/sequential select problem
Next
From: gjerde@icebox.org
Date:
Subject: Re: [SQL] JOIN index/sequential select problem