"David Jaquay" <djaquay(at)gmail(dot)com> 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