Re: 7.4 dramatically slower than 7.3?

Tom Lane wrote:
> Right.  In 7.3 your use of JOIN syntax limited the planner's search for
> good plans; in 7.4 it doesn't do so (by default anyway).  You may care
> to read http://www.postgresql.org/docs/7.4/static/explicit-joins.html
> and experiment with altering JOIN_COLLAPSE_LIMIT (and/or reordering the
> joins in your query).

Thx all, I'll try that
--
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de