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

help / color / mirror / Atom feed
From: Josh berkus <josh@agliodbs.com>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Amit Kapila <amit.kapila16@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: Thu, 2 Jun 2016 13:35:32 -0700
Message-ID: <57509894.9080507@agliodbs.com> (raw)
In-Reply-To: <WM!de247c8715b277e7427f9aaacd540544aa13b6024b86cc6bd18c6481f34478ca83e1c40296c1e8a66a23a078bb07191d!@mailstronghold-3.zmailcloud.com>
References: <20160426152217.GA548975@alvherre.pgsql>
	<574DC881.5010006@agliodbs.com>
	<CAA4eK1J+mSjzoWLXe=azqrLDN9KQqPcf7T5=SKbTFWMZHBS5kA@mail.gmail.com>
	<17944.1464790245@sss.pgh.pa.us>
	<CA+TgmoYZtSDViK2ana7NmPkOGX+wpTUjY2iO4whEhsePmtJDjQ@mail.gmail.com>
	<7570.1464816591@sss.pgh.pa.us>
	<CA+TgmoZehxRoiby6Nj9mFO5pz6Ufdd9-bqa9e0zrKsgOZas7TQ@mail.gmail.com>
	<WM!805040707366f5cdb3300e025b7980c02089ce1331b645738e0eed164506a414e003d0d5027fbf21b435d5f3062c9bcf!@mailstronghold-1.zmailcloud.com>
	<575051AF.2090101@agliodbs.com>
	<21660.1464882811@sss.pgh.pa.us>
	<WM!724b24b17b93e28a639b08a6942b6a6157bfdd1279efab51af9a99d9a9c64a20e4b0cbbd1a06bbecfc8587389a6f6b67!@mailstronghold-1.zmailcloud.com>
	<57508E69.9000505@agliodbs.com>
	<CAKFQuwbJwf26X0JFOWMLZYpaUobmDVEsp3YDvNhHtM8YDNbaKQ@mail.gmail.com>
	<WM!de247c8715b277e7427f9aaacd540544aa13b6024b86cc6bd18c6481f34478ca83e1c40296c1e8a66a23a078bb07191d!@mailstronghold-3.zmailcloud.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 06/02/2016 01:08 PM, David G. Johnston wrote:
> On Thu, Jun 2, 2016 at 3:52 PM, Josh berkus <josh@agliodbs.com
> <mailto:josh@agliodbs.com>>wrote:
> 
>     On 06/02/2016 08:53 AM, Tom Lane wrote:
>     > Josh berkus <josh@agliodbs.com <mailto:josh@agliodbs.com>> writes:
>     >> On 06/02/2016 04:58 AM, Robert Haas wrote:
>     >>> Well, I think we could drop node, if you like.  I think parallel
>     >>> wouldn't be good to drop, though, because it sounds like we want a
>     >>> global limit on parallel workers also, and that can't be just
>     >>> max_workers.  So I think we should keep parallel in there for all of
>     >>> them, and have max_parallel_workers and
>     >>> max_parallel_workers_per_gather(_node).  The reloption and the Path
>     >>> struct field can be parallel_workers rather than parallel_degree.
>     >
>     >> So does that mean we'll rename it if you manage to implement a parameter
>     >> which controls the number of workers for the whole statement?
>     >
>     > That would fit in as something like max_parallel_workers_per_statement.
> 
>     ETOOMANYKNOBS
> 
>     I'm trying to think of some way we can reasonably automate this for
>     users ...
> 
> 
> ​Are you referring to right now or if we move the goal posts to making
> this a per-statement reservation?​

I was assuming that we would have *both* per-operation and per-statement
limits.  I can see reasons for having both, I can see why power users
would want both, but it's going to be overwhelming to casual users.


-- 
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)


-- 
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: <57509894.9080507@agliodbs.com>
Permalink:  ../57509894.9080507@agliodbs.com/
Also on:    postgresql.org/message-id/57509894.9080507@agliodbs.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: josh@agliodbs.com, david.g.johnston@gmail.com, tgl@sss.pgh.pa.us, robertmhaas@gmail.com, amit.kapila16@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: <57509894.9080507@agliodbs.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