Hi David, On Tuesday 08 December 2009 10:59:51 Schmitz, David wrote: > >> With our data it is a performance difference from 1h16min > >> (8.3.8) to 2h43min (8.4.1) > On Postgresql 8.4.1 > Total runtime: 101.446 ms > and on Postgresql 8.3.8: > Total runtime: 29.366 ms Hm. There obviously is more going on than these queries? > Hash Join (cost=2603.57..124518.03 rows=60772 width=61) (actual time=62.359..97.268 rows=1444 loops=1) > Nested Loop (cost=21.00..3790.18 rows=81 width=61) (actual time=0.210..26.098 rows=1444 loops=1) Both misestimate the resultset quite a bit. It looks like happenstance that the one on 8.3 turns out to be better... Andres -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
