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

Nabil Sayegh <postgresql(at)e-trolley(dot)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