[PERFORM] another 8.1-8.4 regression

2010-02-16 Thread Ben Chobot
I'm having problems with another one of my queries after moving from 8.1.19 to 8.4.2. On 8.1.19, the plan looked like this: http://wood.silentmedia.com/bench/8119 That runs pretty well. On 8.4.2, the same query looks like this: http://wood.silentmedia.com/bench/842_bad If I turn off mergejoin

Re: [PERFORM] another 8.1-8.4 regression

2010-02-16 Thread Ben Chobot
On Feb 16, 2010, at 1:29 PM, Ben Chobot wrote: I'm having problems with another one of my queries after moving from 8.1.19 to 8.4.2. On 8.1.19, the plan looked like this: http://wood.silentmedia.com/bench/8119 That runs pretty well. On 8.4.2, the same query looks like this: