Re: Rename max_parallel_degree?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Peter Geoghegan <pg(at)heroku(dot)com>
Cc: Josh berkus <josh(at)agliodbs(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:17:35
Message-ID: CAKFQuwbevu7RXCurir1AO-b+b0c38KQgaOMouuRcHrvcOfnndQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tuesday, May 31, 2016, Peter Geoghegan <pg(at)heroku(dot)com> wrote:

> On Tue, May 31, 2016 at 11:02 AM, Josh berkus <josh(at)agliodbs(dot)com
> <javascript:;>> wrote:
> > I get where you're coming from, but I think Haas's query plan output is
> > going to show us the confusion we're going to get. So we need to either
> > change the parameter, the explain output, or brace ourselves for endless
> > repeated questions.
>
> I get where you're coming from, too -- I think our positions are very
> close.
>
> The only reason I favor defining parallel_degree = 1, rather than
> doing what Tom proposes to do with that patch, is that we might as
> well use the prevailing terminology used by SQL Server and Oracle (as
> long as we match those semantics). Also, I think that number of cores
> used is a more important consideration for users than the number of
> workers used.
>
> Users will definitely be confused about workers used vs. cores used,
> but I don't think that any proposal fixes that.
>
>
Ideally each worker gets its own core - though obviously physical
limitations apply. If that's not the case then, yes, at least one user is
confused...

David J.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2016-05-31 18:18:13 Re: Rename max_parallel_degree?
Previous Message Peter Eisentraut 2016-05-31 18:17:32 Re: Rename max_parallel_degree?