Nabil Sayegh <postgresql@e-trolley.de> writes:
> 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)
You're showing actual time of 18 msec vs 34 msec in 7.3, which doesn't
work out to 40 times slower on my calculator. If there's a problem here
you're not showing it.
regards, tom lane