Re: [BUGS] BUG #14473: Parallel query aborts with too many connections

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: [BUGS] BUG #14473: Parallel query aborts with too many connections
Дата
Msg-id CAA4eK1+FGDU17voS669j3Rb5Tmb3ZgVPtN-1fJh5WdxmXGjc-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14473: Parallel query aborts with too manyconnections  (Steven Winfield <Steven.Winfield@cantabcapital.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [BUGS] BUG #14473: Parallel query aborts with too many connections
Следующее
От: Steven Winfield
Дата:
Сообщение: Re: [BUGS] BUG #14473: Parallel query aborts with too manyconnections