Re: [PERFORM] Yet another abort-early plan disaster on 9.3

2014-09-22 Thread Josh Berkus
On 09/22/2014 06:55 AM, Merlin Moncure wrote: > Has any progress been made on the performance farm? The problem with > suggestions like this (which seem pretty reasonable to me) is that > we've got no way of quantifying the downside. Yeah, that's certainly an issue. The problem is that we'd need

Re: [PERFORM] Yet another abort-early plan disaster on 9.3

2014-09-22 Thread Merlin Moncure
On Sat, Sep 20, 2014 at 1:33 PM, Josh Berkus wrote: > For example, we could increase the estimated cost > for an abort-early index scan by 10X, to reflect our weak confidence in > its correctness. Has any progress been made on the performance farm? The problem with suggestions like this (which s

Re: [PERFORM] postgres 9.3 vs. 9.4

2014-09-22 Thread Merlin Moncure
On Fri, Sep 19, 2014 at 6:58 PM, Mark Kirkwood wrote: > On 19/09/14 19:24, Mkrtchyan, Tigran wrote: >> >> >> >> - Original Message - >>> >>> From: "Mark Kirkwood" >>> To: "Tigran Mkrtchyan" >>> Cc: "Merlin Moncure" , "postgres performance list" >>> >>> Sent: Friday, September 19, 2014 8