Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b7nGj-0003Qw-9D for pgsql-hackers@arkaria.postgresql.org; Tue, 31 May 2016 17:15:53 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b7nGi-00028r-Rb for pgsql-hackers@arkaria.postgresql.org; Tue, 31 May 2016 17:15:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b7nFM-0000a4-NF for pgsql-hackers@postgresql.org; Tue, 31 May 2016 17:14:28 +0000 Received: from lists.commandprompt.com ([69.168.55.30]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b7nFG-0000sD-Tj for pgsql-hackers@postgresql.org; Tue, 31 May 2016 17:14:27 +0000 Received: from [172.30.2.37] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 664F231B; Tue, 31 May 2016 10:14:19 -0700 (PDT) Received: from block-208.123.207.82.montanasat.net ([208.123.207.82] helo=[172.30.2.37]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.4.5); 31 May 2016 10:14:18 -0700 Subject: Re: Rename max_parallel_degree? To: Josh berkus , Tom Lane References: <20160426152217.GA548975@alvherre.pgsql> <8684.1461685466@sss.pgh.pa.us> <20160529053300.GD496776@tornado.leadboat.com> <574DBEA4.9000205@agliodbs.com> <8716.1464714201@sss.pgh.pa.us> <574DC585.7010507@agliodbs.com> Cc: Robert Haas , Noah Misch , David Rowley , Amit Kapila , Alvaro Herrera , Magnus Hagander , Bruce Momjian , PostgreSQL-development From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <574DC669.703@commandprompt.com> Date: Tue, 31 May 2016 10:14:17 -0700 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.8.0 MIME-Version: 1.0 In-Reply-To: <574DC585.7010507@agliodbs.com> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.4.5(15162) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-14859-11533 X-Assp-Session: 7F253084C788 (mail 1) X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-hackers@postgresql.org X-Assp-Intended-For: bruce@momjian.us X-Assp-Intended-For: magnus@hagander.net X-Assp-Intended-For: alvherre@2ndquadrant.com X-Assp-Intended-For: amit.kapila16@gmail.com X-Assp-Intended-For: david.rowley@2ndquadrant.com X-Assp-Intended-For: noah@leadboat.com X-Assp-Intended-For: robertmhaas@gmail.com X-Assp-Intended-For: tgl@sss.pgh.pa.us X-Assp-Intended-For: josh@agliodbs.com X-Assp-Original-Subject: Re: [HACKERS] Rename max_parallel_degree? X-Assp-Client-SSL: yes X-Pg-Spam-Score: -3.3 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 05/31/2016 10:10 AM, Josh berkus wrote: > Compare this: > > "max_parallel is the maximum number of parallel workers which will work > on each stage of the query which is parallizable. If you set it to 4, > you get up to 4 workers." > > with this: > > "max_parallel_degree is the amount of parallelism in the query, with the > understanding that the original parent process counts as 1, which means > that if you set it to 1 you get no parallelism, and if you want 4 > parallel workers you need to set it to 5." > > Which one of those is going to require more explanations on -general and > -novice? Bets? > > Let's not be complicated for the sake of being complicated. > +1 -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers