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: > > htt

[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