Re: 7.4 dramatically slower than 7.3?

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: 7.4 dramatically slower than 7.3?
Date: 2004-04-07 12:49:17
Message-ID: 4073F8CD.2000305@e-trolley.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Guerin 2004-04-07 18:55:12 table space keeps growing.
Previous Message DAVANNE Eric - NTR 2004-04-07 09:31:49 uninstall postgres_beta4