pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Julien Rouhaud <julien.rouhaud@dalibo.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: Peter Geoghegan <pg@heroku.com>
Cc: Noah Misch <noah@leadboat.com>
Cc: David Rowley <david.rowley@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Rename max_parallel_degree?
Date: Wed, 29 Jun 2016 16:00:57 +0200
Message-ID: <fab6510f-a303-4144-06c3-e2e63ca50d30@dalibo.com> (raw)
In-Reply-To: <CAA4eK1JNVHTQ_yE7XqsKNgS2aR7_No0ymOvFFU_Jk5j7jpmkgg@mail.gmail.com>
References: <20160426152217.GA548975@alvherre.pgsql>
	<CA+TgmobpC00y0tbTZ+nioH3teKBYQUis0DjG9sQaiN7i0g6VWA@mail.gmail.com>
	<2b70e5a6-28fe-6601-d294-cd568930265f@dalibo.com>
	<79f47dd2-819a-940a-5912-5ff643e87b54@dalibo.com>
	<CAA4eK1+MR0+ZkF5NadZdddMs=KqqCLbEDGR=GX7bYcWu9K+s5g@mail.gmail.com>
	<98adbca7-3bec-7ee4-92b0-893a0ace5cca@dalibo.com>
	<CAA4eK1+SPLt3M0znpNK1qGbKtiC3XmvoOoSP=Bf7bgmQ2P_pkA@mail.gmail.com>
	<a1bcad71-db24-2d47-843d-f9fa9677da11@dalibo.com>
	<CAA4eK1J3ZnTBSQv7-YxH9g=9h9L0cEiNU3pqeOZC9=pa_9=Rsw@mail.gmail.com>
	<CAA4eK1+Q_DdJ28qXYSHZiBKNf2MY1QFrv5XAOAw4ZXHw4TPMxA@mail.gmail.com>
	<f3421024-c236-a728-4cb4-38404b69bc9f@dalibo.com>
	<CAA4eK1KZh_qDtZJALYY9oDHjzAKYJAZsqwOXNTiL91WFDSFhzg@mail.gmail.com>
	<9f84548d-8b59-b5c8-510d-991f8ee3ab20@dalibo.com>
	<CAA4eK1+4uvbf6gefPEhXMD40R_Q+qDfBGw9SGHWMkqxszx+=tA@mail.gmail.com>
	<20312f33-c14e-0d3f-a79f-95212f64a38c@dalibo.com>
	<CAA4eK1JNVHTQ_yE7XqsKNgS2aR7_No0ymOvFFU_Jk5j7jpmkgg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 29/06/2016 08:51, Amit Kapila wrote:
> On Wed, Jun 29, 2016 at 11:54 AM, Julien Rouhaud
> <julien.rouhaud@dalibo.com> wrote:
>> Or should we allow setting it to -1 for instance to disable the limit?
>>
> 
> By disabling the limit, do you mean to say that only
> max_parallel_workers_per_gather will determine the workers required or
> something else?

I meant what the current behavior (before this patch) is, which is
probably what some user without custom dynamic bgworker may like to
have.  Otherwise, you'd have to change two parameters to effectively
increase parallelism, and I think it can also cause some confusion.

>  If earlier, then I am not sure if it is good idea,
> because it can cause some confusion to the user about usage of both
> the parameters together.
> 

I also agree.  I don't see an ideal solution, so just keeping this patch
behavior is fine for me.

-- 
Julien Rouhaud
http://dalibo.com - http://dalibo.org


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (185+ messages)  latest in thread

Message-ID: <fab6510f-a303-4144-06c3-e2e63ca50d30@dalibo.com>
Permalink:  ../fab6510f-a303-4144-06c3-e2e63ca50d30@dalibo.com/
Also on:    postgresql.org/message-id/fab6510f-a303-4144-06c3-e2e63ca50d30@dalibo.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: julien.rouhaud@dalibo.com, amit.kapila16@gmail.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, josh@agliodbs.com, david.g.johnston@gmail.com, pg@heroku.com, noah@leadboat.com, david.rowley@2ndquadrant.com, alvherre@2ndquadrant.com, magnus@hagander.net, bruce@momjian.us
  Subject: Re: Rename max_parallel_degree?
  In-Reply-To: <fab6510f-a303-4144-06c3-e2e63ca50d30@dalibo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox