Re: 7.4 dramatically slower than 7.3? (was: snowflaking)

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