Re: 7.4 dramatically slower than 7.3?

Stephan Szabo wrote:
> On Tue, 6 Apr 2004, Nabil Sayegh wrote:
>
>
>>When I take the query of my first post and EXPLAIN ANALYZE it with 7.3 I get the following output:
>>----------------------------------------------------------------------------------------------------
>> Hash Join (cost=85.66..213.16 rows=1 width=240) (actual time=34.01..34.47 rows=1 loops=1)
>
>
>>Now I tested it with 7.4 to see if gets faster, but guess what?
>>It's about 40 times slower(!):
>>
>>----------------------------------------------------------------------------------------------------
>> Merge Left Join (cost=142.22..142.28 rows=2 width=0) (actual time=18.681..18.684 rows=1 loops=1)
>
>
> Hmm, this actual time number seems about 1/2 the above unless I'm missing
> something (34 vs 19). Is it possible you missed some lines or something
> while posting?

I posted only the first few lines (it's repeating).

But I found the solution/problem:
If I use JOIN instead of LEFT OUTER JOIN it is on 7.4 as fast as on 7.3
(At the moment there are no NULL values, so for the moment I can live without the LEFT OUTER JOIN).

But how can it be, that the query with LEFT OUTER JOIN has the same speed on 7.3 but is 40 times
slower on 7.4?

TFYH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de