Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))

2018-07-09 Thread Bruce Momjian
On Fri, Jun 22, 2018 at 02:53:36PM +0530, Amit Kapila wrote: > On Wed, Jun 20, 2018 at 8:43 PM, Bruce Momjian wrote: > > On Thu, May 24, 2018 at 08:00:25PM -0500, Justin Pryzby wrote: > > > > So I did some research on this, particularly to find out how it was > > missed in the PG 10 release

Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))

2018-06-22 Thread Amit Kapila
On Wed, Jun 20, 2018 at 8:43 PM, Bruce Momjian wrote: > On Thu, May 24, 2018 at 08:00:25PM -0500, Justin Pryzby wrote: > > So I did some research on this, particularly to find out how it was > missed in the PG 10 release notes. It turns out that > max_parallel_workers_per_gather has always

Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))

2018-06-20 Thread Bruce Momjian
On Thu, May 24, 2018 at 08:00:25PM -0500, Justin Pryzby wrote: > Moving to -hackers; > > On Sun, Jan 28, 2018 at 06:53:10PM -0500, Bruce Momjian wrote: > > On Thu, Oct 26, 2017 at 02:45:15PM -0500, Justin Pryzby wrote: > > > Is it because max_parallel_workers_per_gather now defaults to 2 ? > > >

add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))

2018-05-24 Thread Justin Pryzby
Moving to -hackers; On Sun, Jan 28, 2018 at 06:53:10PM -0500, Bruce Momjian wrote: > On Thu, Oct 26, 2017 at 02:45:15PM -0500, Justin Pryzby wrote: > > Is it because max_parallel_workers_per_gather now defaults to 2 ? > > > > BTW, I would tentatively expect a change in default to be documented