Re: [PERFORM] Query plan good in 8.4, bad in 9.2 and better in 9.3

2014-05-19 Thread Scott Marlowe
On Thu, May 15, 2014 at 10:52 AM, Tom Lane wrote: > Scott Marlowe writes: >> OK so we have a query that does OK in 8.4, goes to absolute crap in >> 9.2 and then works great in 9.3. Thing is we've spent several months >> regression testing 9.2 and no time testing 9.3, so we can't just "go >> to 9.

Re: [PERFORM] Query plan good in 8.4, bad in 9.2 and better in 9.3

2014-05-15 Thread Jeff Janes
On Thu, May 15, 2014 at 9:35 AM, Scott Marlowe wrote: > OK so we have a query that does OK in 8.4, goes to absolute crap in > 9.2 and then works great in 9.3. Thing is we've spent several months > regression testing 9.2 and no time testing 9.3, so we can't just "go > to 9.3" in an afternoon. But w

Re: [PERFORM] Query plan good in 8.4, bad in 9.2 and better in 9.3

2014-05-15 Thread Tom Lane
Scott Marlowe writes: > OK so we have a query that does OK in 8.4, goes to absolute crap in > 9.2 and then works great in 9.3. Thing is we've spent several months > regression testing 9.2 and no time testing 9.3, so we can't just "go > to 9.3" in an afternoon. But we might have to. 9.2 seems hopel