Re: Rename max_parallel_degree?
От
Peter Geoghegan
Тема
Re: Rename max_parallel_degree?
Дата
Msg-id
CAM3SWZR6cd4v-LMmu9hoMR0pRVH9hKPSchEyH=v6BOo7OdhY5Q@mail.gmail.com
Ответ на
Re: Rename max_parallel_degree? (Josh berkus)
Список
Дерево обсуждения
Rename max_parallel_degree? Bruce Momjian <bruce@momjian.us>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Tom Lane <tgl@sss.pgh.pa.us>
Re: Rename max_parallel_degree? Bruce Momjian <bruce@momjian.us>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Geoff Winkless <pgsqladmin@geoff.dj>
Re: Rename max_parallel_degree? Magnus Hagander <magnus@hagander.net>
Re: Rename max_parallel_degree? Tom Lane <tgl@sss.pgh.pa.us>
Re: Rename max_parallel_degree? Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Tom Lane <tgl@sss.pgh.pa.us>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Peter Geoghegan <pg@heroku.com>
Re: Rename max_parallel_degree? Peter Geoghegan <pg@heroku.com>
Re: Rename max_parallel_degree? Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Tom Lane <tgl@sss.pgh.pa.us>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Tom Lane <tgl@sss.pgh.pa.us>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Christoph Berg <myon@debian.org>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Amit Kapila <amit.kapila16@gmail.com>
Re: Rename max_parallel_degree? David Rowley <david.rowley@2ndquadrant.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Noah Misch <noah@leadboat.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? "Daniel Verite" <daniel@manitou-mail.org>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? David Rowley <david.rowley@2ndquadrant.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? Magnus Hagander <magnus@hagander.net>
Re: Rename max_parallel_degree? Bruce Momjian <bruce@momjian.us>
Re: Rename max_parallel_degree? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Rename max_parallel_degree? Amit Kapila <amit.kapila16@gmail.com>
Re: Rename max_parallel_degree? Bruce Momjian <bruce@momjian.us>
Re: Rename max_parallel_degree? "Joshua D. Drake" <jd@commandprompt.com>
Re: Rename max_parallel_degree? Robert Haas <robertmhaas@gmail.com>
Re: Rename max_parallel_degree? "Joshua D. Drake" <jd@commandprompt.com>
Re: Rename max_parallel_degree? Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Rename max_parallel_degree? Peter Geoghegan <pg@bowt.ie>
Re: Rename max_parallel_degree? "Joshua D. Drake" <jd@commandprompt.com>
On Tue, May 31, 2016 at 10:10 AM, Josh berkus wrote: > "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. But the distinction between parallel workers and backends that can participate in parallel query does need to be user-visible. Worker processes are a commodity (i.e. the user must consider max_worker_processes). -- Peter Geoghegan
В списке pgsql-hackers по дате отправления
От: Tomas Vondra
Дата: