=?iso-8859-1?q?Jeff=20Anto?= <antojf2001(at)yahoo(dot)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