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?
