"David Jaquay" <djaquay@xxxxxxxxx> writes: > How exactly can you control the join order? http://www.postgresql.org/docs/8.2/static/explicit-joins.html (adjust link for your PG version, as this material changes from release to release) > 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). Could you show us some specific examples? I'm usually more interested in fixing the planner than overriding it. regards, tom lane
