Re: 7.4 dramatically slower than 7.3? - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: 7.4 dramatically slower than 7.3?
Date
Msg-id 4073F8CD.2000305@e-trolley.de
Whole thread Raw
In response to Re: 7.4 dramatically slower than 7.3?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: DAVANNE Eric - NTR
Date:
Subject: uninstall postgres_beta4
Next
From: Michael Guerin
Date:
Subject: table space keeps growing.