Stephan Szabo wrote:
> One other possibility is that the planning is taking a really long time.
> How long do explain (non-analyze) on the two systems take? And how many
> joins are there precisely?
Yeah, that seems to be it.
It takes ~
(real) 3.776s on 7.4
(real) 0.082s on 7.3
measured with bash/time but shouldn't make a difference
So the plan is actually better but takes much longer to ... plan, right?
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
pgsql-novice by date
|Next:||From: Stephan Szabo||Date: 2004-04-06 16:21:45|
|Subject: Re: 7.4 dramatically slower than 7.3?|
|Previous:||From: George Weaver||Date: 2004-04-06 15:26:59|
|Subject: Re: dotnet stored procedures with postgresql|