Re: outer joins complexity

=?iso-8859-1?q?Jeff=20Anto?= <antojf2001@yahoo.fr> writes:
> I'm looking for outer join complexity hints.

> I did a vacuum analyze before that. Did PostGres see
> that fichier_prepub is a small table (89 rows)

Small or not, the join order is constrained when you use outer joins,
so the planner has only limited opportunity for being smart.  See
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/explicit-joins.html

            regards, tom lane