"David Jaquay" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
