Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-15 Thread Robert Haas
On Mon, Aug 15, 2016 at 9:10 PM, Tom Lane wrote: > Robert Haas writes: >> On Sat, Aug 13, 2016 at 11:56 AM, Alvaro Herrera >> wrote: >>> I too prefer to keep it turned off in 9.6 and consider enabling it by >>> default on a future release (10 is probably good). Interested users can >>> carefull

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-15 Thread Tom Lane
Robert Haas writes: > On Sat, Aug 13, 2016 at 11:56 AM, Alvaro Herrera > wrote: >> I too prefer to keep it turned off in 9.6 and consider enabling it by >> default on a future release (10 is probably good). Interested users can >> carefully test the feature without endangering other unsuspecting

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-15 Thread Robert Haas
On Sat, Aug 13, 2016 at 11:56 AM, Alvaro Herrera wrote: > Michael Paquier wrote: > >> Being cautious pays more in the long term, so seeing the number of >> bugs that showed up I'd rather vote for having it disabled by default >> in 9.6 stable, and enabled on master to aim at enabling it in 10.0. >

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-13 Thread Alvaro Herrera
Michael Paquier wrote: > Being cautious pays more in the long term, so seeing the number of > bugs that showed up I'd rather vote for having it disabled by default > in 9.6 stable, and enabled on master to aim at enabling it in 10.0. I too prefer to keep it turned off in 9.6 and consider enabling

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-04 Thread Michael Paquier
On Thu, Aug 4, 2016 at 10:52 PM, David G. Johnston wrote: > My initial reaction was +1 but now I'm leaning toward enabled by default. > > Those who would upgrade to 9.6 within a year of its release are most likely, > process and personality wise, to be those for whom the risks and rewards of > new

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-04 Thread David G. Johnston
On Thu, Aug 4, 2016 at 9:25 AM, Robert Haas wrote: > On Thu, Aug 4, 2016 at 12:56 AM, Tom Lane wrote: > > Noah Misch writes: > >> On Wed, Apr 20, 2016 at 02:28:15PM -0400, Tom Lane wrote: > >>> +1, but let's put an entry on the 9.6 open-items page to remind us to > >>> make that decision at the

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-04 Thread Robert Haas
On Thu, Aug 4, 2016 at 12:56 AM, Tom Lane wrote: > Noah Misch writes: >> On Wed, Apr 20, 2016 at 02:28:15PM -0400, Tom Lane wrote: >>> +1, but let's put an entry on the 9.6 open-items page to remind us to >>> make that decision at the right time. > >> It's that time. Do we restore the max_parall

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-03 Thread Tom Lane
Noah Misch writes: > On Wed, Apr 20, 2016 at 02:28:15PM -0400, Tom Lane wrote: >> +1, but let's put an entry on the 9.6 open-items page to remind us to >> make that decision at the right time. > It's that time. Do we restore the max_parallel_workers_per_gather=0 default, > or is enabling this by

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-08-03 Thread Noah Misch
On Wed, Apr 20, 2016 at 02:28:15PM -0400, Tom Lane wrote: > Andres Freund writes: > > max_parallel_degree currently defaults to 0. I think we should enable > > it by default for at least the beta period. Otherwise we're primarily > > going to get reports back after the release. > > > Then, at th

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-23 Thread Gavin Flower
On 22/04/16 17:36, Amit Kapila wrote: On Fri, Apr 22, 2016 at 1:31 AM, Gavin Flower mailto:gavinflo...@archidevsys.co.nz>> wrote: On 22/04/16 06:07, Robert Haas wrote: On Thu, Apr 21, 2016 at 1:48 PM, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: Robert Haas mailto:robe

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-22 Thread Gavin Flower
On 23/04/16 00:56, Robert Haas wrote: On Thu, Apr 21, 2016 at 7:20 PM, Tom Lane wrote: Robert Haas writes: On Thu, Apr 21, 2016 at 4:01 PM, Gavin Flower wrote: Why not 4? As most processors now have at least 4 physical cores, & surely it be more likely to flush out race conditions. Becaus

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-22 Thread Robert Haas
On Fri, Apr 22, 2016 at 10:07 AM, Joshua D. Drake wrote: > This is the problem right here. > > We should be shipping for a reasonable production configuration. It is not > reasonable to assume that someone is going to be running on a Rasberry Pi 2. > Yes, we can effectively run on that platform t

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-22 Thread Joshua D. Drake
On 04/22/2016 06:47 AM, Robert Haas wrote: On Fri, Apr 22, 2016 at 9:33 AM, Tom Lane wrote: Robert Haas writes: On Thu, Apr 21, 2016 at 7:20 PM, Tom Lane wrote: Is that because max_worker_processes is only 8 by default? Maybe we need to raise that, at least for beta purposes? I'm not re

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-22 Thread Robert Haas
On Fri, Apr 22, 2016 at 9:33 AM, Tom Lane wrote: > Robert Haas writes: >> On Thu, Apr 21, 2016 at 7:20 PM, Tom Lane wrote: >>> Is that because max_worker_processes is only 8 by default? Maybe we >>> need to raise that, at least for beta purposes? > >> I'm not really in favor of that. I mean, a

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-22 Thread Tom Lane
Robert Haas writes: > On Thu, Apr 21, 2016 at 7:20 PM, Tom Lane wrote: >> Is that because max_worker_processes is only 8 by default? Maybe we >> need to raise that, at least for beta purposes? > I'm not really in favor of that. I mean, almost all of our default > settings are optimized for run

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-22 Thread Andreas Joseph Krogh
På fredag 22. april 2016 kl. 14:56:33, skrev Robert Haas mailto:robertmh...@gmail.com>>: On Thu, Apr 21, 2016 at 7:20 PM, Tom Lane wrote: > Robert Haas writes: >> On Thu, Apr 21, 2016 at 4:01 PM, Gavin Flower >> wrote: >>> Why not 4?  As most processors now have at least 4 physical cores, &

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-22 Thread Robert Haas
On Thu, Apr 21, 2016 at 7:20 PM, Tom Lane wrote: > Robert Haas writes: >> On Thu, Apr 21, 2016 at 4:01 PM, Gavin Flower >> wrote: >>> Why not 4? As most processors now have at least 4 physical cores, & surely >>> it be more likely to flush out race conditions. > >> Because if we did that, then

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-21 Thread Amit Kapila
On Fri, Apr 22, 2016 at 1:31 AM, Gavin Flower wrote: > On 22/04/16 06:07, Robert Haas wrote: > >> On Thu, Apr 21, 2016 at 1:48 PM, Tom Lane wrote: >> >>> Robert Haas writes: >>> On Wed, Apr 20, 2016 at 2:28 PM, Tom Lane wrote: > Andres Freund writes: > >> max_parallel_de

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-21 Thread Tom Lane
Robert Haas writes: > On Thu, Apr 21, 2016 at 4:01 PM, Gavin Flower > wrote: >> Why not 4? As most processors now have at least 4 physical cores, & surely >> it be more likely to flush out race conditions. > Because if we did that, then it's extremely likely that people would > end up writing q

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-21 Thread Robert Haas
On Thu, Apr 21, 2016 at 4:01 PM, Gavin Flower wrote: > On 22/04/16 06:07, Robert Haas wrote: >> >> On Thu, Apr 21, 2016 at 1:48 PM, Tom Lane wrote: >>> >>> Robert Haas writes: On Wed, Apr 20, 2016 at 2:28 PM, Tom Lane wrote: > > Andres Freund writes: >> >> max_paralle

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-21 Thread Gavin Flower
On 22/04/16 06:07, Robert Haas wrote: On Thu, Apr 21, 2016 at 1:48 PM, Tom Lane wrote: Robert Haas writes: On Wed, Apr 20, 2016 at 2:28 PM, Tom Lane wrote: Andres Freund writes: max_parallel_degree currently defaults to 0. I think we should enable it by default for at least the beta peri

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-21 Thread Robert Haas
On Thu, Apr 21, 2016 at 1:48 PM, Tom Lane wrote: > Robert Haas writes: >> On Wed, Apr 20, 2016 at 2:28 PM, Tom Lane wrote: >>> Andres Freund writes: max_parallel_degree currently defaults to 0. I think we should enable it by default for at least the beta period. Otherwise we're prima

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-21 Thread Tom Lane
Robert Haas writes: > On Wed, Apr 20, 2016 at 2:28 PM, Tom Lane wrote: >> Andres Freund writes: >>> max_parallel_degree currently defaults to 0. I think we should enable >>> it by default for at least the beta period. Otherwise we're primarily >>> going to get reports back after the release. >

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-21 Thread Robert Haas
On Wed, Apr 20, 2016 at 2:28 PM, Tom Lane wrote: > Andres Freund writes: >> max_parallel_degree currently defaults to 0. I think we should enable >> it by default for at least the beta period. Otherwise we're primarily >> going to get reports back after the release. > >> Then, at the end of beta

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-20 Thread Tom Lane
Andres Freund writes: > max_parallel_degree currently defaults to 0. I think we should enable > it by default for at least the beta period. Otherwise we're primarily > going to get reports back after the release. > Then, at the end of beta, we can decide what the default should be. +1, but let'

Re: [HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-20 Thread Andreas Joseph Krogh
På onsdag 20. april 2016 kl. 19:46:31, skrev Andres Freund mailto:and...@anarazel.de>>: Hi, max_parallel_degree currently defaults to 0.  I think we should enable it by default for at least the beta period. Otherwise we're primarily going to get reports back after the release. Then, at the en

[HACKERS] max_parallel_degree > 0 for 9.6 beta

2016-04-20 Thread Andres Freund
Hi, max_parallel_degree currently defaults to 0. I think we should enable it by default for at least the beta period. Otherwise we're primarily going to get reports back after the release. Then, at the end of beta, we can decide what the default should be. - Andres -- Sent via pgsql-hackers