Re: [BUGS] BUG #14473: Parallel query aborts with too many connections - Mailing list pgsql-bugs

From Amit Kapila
Subject Re: [BUGS] BUG #14473: Parallel query aborts with too many connections
Date
Msg-id CAA4eK1+FGDU17voS669j3Rb5Tmb3ZgVPtN-1fJh5WdxmXGjc-g@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14473: Parallel query aborts with too manyconnections  (Steven Winfield <Steven.Winfield@cantabcapital.com>)
List pgsql-bugs
On Fri, Dec 23, 2016 at 3:47 PM, Steven Winfield
<Steven.Winfield@cantabcapital.com> wrote:
>
> OTOH, if parallel queries could be made tolerant of workers failing to start
> then there wouldn't be as much of an issue (though doubtless this is easier
> said than done!)
>

I think it is difficult to decide which errors parallel query be made
tolerant.  I also don't think it is advisable to make parallel query
handle some errors.  I think here DBA should carefully use the
connection limits.  I think it might be okay to add a note in parallel
query docs to indicate that parallel workers use database connection.

-- 
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [BUGS] BUG #14473: Parallel query aborts with too many connections
Next
From: Steven Winfield
Date:
Subject: Re: [BUGS] BUG #14473: Parallel query aborts with too manyconnections