Re: [HACKERS] enable parallel query by default?

On 02/08/2016 01:07 PM, Robert Haas wrote: Hi, One of the questions I have about parallel query is whether it should be enabled by default. That is, should we make the default value of max_parallel_degree to a value higher than 0? Perhaps 1, say? O.k. after some googling where I found your

Re: [HACKERS] enable parallel query by default?

Hi, On 2016-02-08 16:07:05 -0500, Robert Haas wrote: > One of the questions I have about parallel query is whether it should > be enabled by default. That is, should we make the default value of > max_parallel_degree to a value higher than 0? Perhaps 1, say? > > There are some good reasons why

Re: [HACKERS] enable parallel query by default?

Robert Haas writes: > One of the questions I have about parallel query is whether it should > be enabled by default. That is, should we make the default value of > max_parallel_degree to a value higher than 0? Perhaps 1, say? I'm not sure I'm on board with that as a

Re: [HACKERS] enable parallel query by default?

On Mon, Feb 8, 2016 at 1:24 PM, Andres Freund wrote: > I think that's an argument to enable it till at least beta1. Let's > change the default, and add an item to the open items list to reconsider > then. +1. Reminds me of what happened with the num_xloginsert_locks GUC (it

[HACKERS] enable parallel query by default?

Hi, One of the questions I have about parallel query is whether it should be enabled by default. That is, should we make the default value of max_parallel_degree to a value higher than 0? Perhaps 1, say? There are some good reasons why this might be a bad idea, such as: - As discussed on a

Re: [HACKERS] enable parallel query by default?

On Monday, February 8, 2016, Andres Freund wrote: > Hi, > > On 2016-02-08 16:07:05 -0500, Robert Haas wrote: > > One of the questions I have about parallel query is whether it should > > be enabled by default. That is, should we make the default value of > >

Re: [HACKERS] enable parallel query by default?

> > I think that's an argument to enable it till at least beta1. Let's >> change the default, and add an item to the open items list to reconsider >> then. >> >> > +1 during the beta, +0.95 for default thereafter. I think that most databases in the past have defaulted to single-core unless