Re: How does filter order relate to query optimization? - Mailing list pgsql-general

From David Jaquay
Subject Re: How does filter order relate to query optimization?
Date
Msg-id ad4aa5a80703280939w510a8247rc23b96a283a74ed6@mail.gmail.com
Whole thread Raw
In response to Re: How does filter order relate to query optimization?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How does filter order relate to query optimization?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
A really long time ago, on 2/27/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Usually what you want to think about for something
> like this is plan optimization, ie, what order are the tables joined in
> and with what join methods.

How exactly can you control the join order?  I have cases where the
explain data indicates that the planner is picking a very inefficient
way to get the data, (i.e. joining two very big tables in their
entirety, then joining that to a 3rd with maybe 10 rows yielding maybe
30).  I'd love to have some more determinacy in dealing with the
planner on complex queries...

Dave

pgsql-general by date:

Previous
From: Mike Charnoky
Date:
Subject: disable/enable trigger hangs
Next
From: Tom Lane
Date:
Subject: Re: How does filter order relate to query optimization?