Re: increased max_parallel_workers_per_gather results in fewer workers? - Mailing list pgsql-performance

From Magnus Hagander
Subject Re: increased max_parallel_workers_per_gather results in fewer workers?
Date
Msg-id CABUevEzvoge5V1fShgKXrfXKTP3KEXJkh+jZ4g6u+DGeLB5g_Q@mail.gmail.com
Whole thread Raw
In response to Re: increased max_parallel_workers_per_gather results in fewerworkers?  (Philip Semanchuk <philip@americanefficient.com>)
List pgsql-performance


On Thu, Jun 4, 2020 at 12:24 AM Philip Semanchuk <philip@americanefficient.com> wrote:


> On Jun 3, 2020, at 5:15 PM, Justin Pryzby <pryzby@telsasoft.com> wrote:
>
> On Wed, Jun 03, 2020 at 04:04:13PM -0400, Philip Semanchuk wrote:
>> Can anyone help me understand why this happens, or where I might look for clues?
>
> What version postgres ?

Sorry, I should have posted that in my initial email.

select version();
+-----------------------------------------------------------------------------+
| version                                                                     |
|-----------------------------------------------------------------------------|
| PostgreSQL 11.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.9.3, 64-bit |
+-----------------------------------------------------------------------------+

This is AWS’ version of Postgres 11.6 (“Aurora”) which of course might make a difference.

Yes, it definitely makes a difference. For Aurora questions you are more likely to get good answers in the AWS forums rather than the PostgreSQL ones.  It's different from PostgreSQL in too many ways, and those differences are not fully known outside of AWS.

--

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: increased max_parallel_workers_per_gather results in fewerworkers?
Next
From: Philip Semanchuk
Date:
Subject: Re: increased max_parallel_workers_per_gather results in fewerworkers?