Re: insane index scan times - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: insane index scan times
Date
Msg-id 9e4684ce0706091227u34fa4a0fy4e5a7c94afbb7926@mail.gmail.com
Whole thread Raw
In response to Re: insane index scan times  (Sergei Shelukhin <realgeek@gmail.com>)
List pgsql-general
On 6/7/07, Sergei Shelukhin <realgeek@gmail.com> wrote:
Version is 8.1
The query I originally ran returned ~4-5 rows and had a lot of other
joins and filtering conditions prior to the join with the big table.
Is there any way to instruct postgres to do joins in the specific
order or smth?

make explain analyze of original query (notice *explain analyze* and not *explain*), and post this to list. otherwise - you can't really hope someone will tell you what's wrong.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pg_hba.conf - md5
Next
From: ABHANG RANE
Date:
Subject: gist index on cube column