Re: [PERFORM] Performance loss upgrading from 9.3 to 9.6

2017-11-06 Thread Adam Torres
). The hope is whatever feature we have not configured properly in 9.6 is not there in 9.4. On 11/6/17, 9:21 AM, "Justin Pryzby" wrote: On Mon, Nov 06, 2017 at 01:18:00PM +0000, Adam Torres wrote: > Good morning all, > > We have a problem with performance a

[PERFORM] Performance loss upgrading from 9.3 to 9.6

2017-11-06 Thread Adam Torres
an for a small dealer on 9.6 run without anything else running on the server https://explain.depesz.com/s/z71u Planning time: 8.218 ms Execution time: 639319.525 ms Same query as run on 9.3 https://explain.depesz.com/s/gjN3 Total runtime: 272897.150 ms -- Thanks, Adam Torres