Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b8gbn-00027v-3H for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Jun 2016 04:21:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b8gbm-0004HM-6C for pgsql-hackers@arkaria.postgresql.org; Fri, 03 Jun 2016 04:21:18 +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 1b8gbk-0004G4-HU for pgsql-hackers@postgresql.org; Fri, 03 Jun 2016 04:21:16 +0000 Received: from mail-wm0-x236.google.com ([2a00:1450:400c:c09::236]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1b8gbh-0003NW-1A for pgsql-hackers@postgresql.org; Fri, 03 Jun 2016 04:21:16 +0000 Received: by mail-wm0-x236.google.com with SMTP id a136so257564875wme.0 for ; Thu, 02 Jun 2016 21:21:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding; bh=ZEphcinFGiTtXufE+r0zQwEOE4qQcfofeXcFrAUI1dA=; b=IgDv8q07eC8Dz3KVI2GCKmby0YverVz19iEvMXwuXZQEeVfHaEtZJ7jcGjoDsdUgwW gI0vP/diKYOzGOzvTt5B5nRYi7Oze8TpUjJjpSdu6paq/yKRayim7KRBYJGUVuIoUxj3 mlDyLou7cPU4xPNt9kB+qcXFHUHegZ+P44Yzwo26ECjEn00EFK+qE7egYpHVYlaXZlfZ WHHhY5bogrU5ksAt/WrJrDlVIeLPEGJEhOxZwgAQvZe8ToSrkpxCe8zfUc3dLtAbo2z3 arhwREztzCUPqpelcIAkLQTtUdDo/4//kcfeBC91LJ+gnAKUt8b3nx1AjEo0MQmQPmku VgzA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:cc:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=ZEphcinFGiTtXufE+r0zQwEOE4qQcfofeXcFrAUI1dA=; b=TgIruQjXkwc4cYOF7mjGzCa1INNI9rvqolPbs8EaKYKguBg4ym2r/vwUUTzPk8Trop 0VpcV8bGJXT+5ipvfFuMaGYP3fiTHiYJq1IEGoZotW8oYZcvWf6A5cLdflvArxIJql9+ 9MxKMU4K+jrOi6v5NBjPtff0df+VDX43j9QDIH4J2n4hfPpIkZF+UmLgA6TjjhMXX0qH Talg4ObG52LpIKS2hNu+3rf0byCsSAD6Jgu7zWj58gJxsPr8OJilXhuJQwbrVvVaRh7y bxSgtlJR1g/OCFJELnX0wqRmPlug0VBv11B4UxFpkR7ovogRflg+uiK7cauQuGQHBjXw 60Lg== X-Gm-Message-State: ALyK8tKw/dS2/misflg59QgQx3lQWokSXDFc2HZfHpFsO+NuPuXTCQI+v3BgplHZB+84nDR/6NO78CaqZX3YrxFORnPWvxkNbkSTIGiVaHMyFqEQhGee0m6XRGvnum9IKSDHmit46KB/kHBnP/KJLzHpPgOjFdUFQsGTQbl063CkU2DwPn6paGgy7KKVHGv4eA== X-Received: by 10.194.22.4 with SMTP id z4mr1158100wje.67.1464927671020; Thu, 02 Jun 2016 21:21:11 -0700 (PDT) Received: from [192.168.0.103] (150.123.broadband11.iol.cz. [90.178.123.150]) by smtp.gmail.com with ESMTPSA id 75sm4286501wml.15.2016.06.02.21.21.09 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 02 Jun 2016 21:21:10 -0700 (PDT) Subject: Re: Rename max_parallel_degree? To: "David G. Johnston" References: <20160531202742.GA896974@alvherre.pgsql> <5641.1464731894@sss.pgh.pa.us> <574F030F.7030108@2ndquadrant.com> Cc: Jim Nasby , Robert Haas , Tom Lane , Alvaro Herrera , Josh berkus , Peter Eisentraut , Peter Geoghegan , Noah Misch , David Rowley , Amit Kapila , Magnus Hagander , Bruce Momjian , PostgreSQL-development From: Petr Jelinek Message-ID: <575105B4.60506@2ndquadrant.com> Date: Fri, 3 Jun 2016 06:21:08 +0200 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: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -2.6 (--) 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 01/06/16 17:55, David G. Johnston wrote: > On Wed, Jun 1, 2016 at 11:45 AM, Petr Jelinek >wrote: > > That GUC also controls worker processes that are started by > extensions, not just ones that parallel query starts. This is btw > one thing I don't like at all about how the current limits work, the > parallel query will fight for workers with extensions because they > share the same limit. > > > ​Given that this models reality the GUC is doing its job. Now, maybe we > need additional knobs to give the end-user the ability to influence how > those fights will turn out. Agreed, my point is that I think we do need additional knob. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers