Re: Rename max_parallel_degree?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Josh berkus <josh(at)agliodbs(dot)com>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Rename max_parallel_degree?
Date: 2016-05-31 18:51:58
Message-ID: CAKFQuwYudvWyz14MmPLMUvz4AAGLLYXNW=h2_cdPk3pp4j5ZXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, May 31, 2016 at 2:37 PM, Josh berkus <josh(at)agliodbs(dot)com> wrote:

> On 05/31/2016 11:27 AM, Peter Geoghegan wrote:
> > On Tue, May 31, 2016 at 11:22 AM, Josh berkus <josh(at)agliodbs(dot)com> wrote:
> >>> I think we can hope that developers are going to be less confused about
> >>> that than users.
> >>
> >> Makes sense.
> >
> > Maybe EXPLAIN doesn't have to use the term parallel worker at all. It
> > can instead use a slightly broader terminology, possibly including the
> > term "core".
>
2. max_parallel_X and EXPLAIN output
>

​This is helped greatly if we can say:

Leader: xxx
Worker 0: yyy
Worker 1: zzz​

​David Rowley's response on April 30th provides an example explain output
should anyone want to an easy source to look at.


https://www.postgresql.org/message-id/CAKJS1f8_3y6XHp2xP5YOvPetXMuCmiWP6zWR_eteRQy2fCn9mQ@mail.gmail.com

Getting across the point that session process are not worker processes
seems doable. The implementation detail that they do indeed perform work
can be made evident in the explain but otherwise left an implementation
detail.

David J.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2016-05-31 18:55:08 Re: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Previous Message Tom Lane 2016-05-31 18:46:47 Re: Rename max_parallel_degree?