Re: Update on

Hello David

After reading the commit I understand it modifies the management so that
parallel workers don't count against connection_limit so I don't
understand why I experience the problem
What do you mean by "hijacked"?

Best regards
Martin

On 27/11/2020 19:30, David G. Johnston wrote:
> On Friday, November 27, 2020, EffiSYS / Martin Querleu
> <martin(dot)querleu(at)effisys(dot)fr <mailto:martin(dot)querleu(at)effisys(dot)fr>> wrote:
>
> Hello
>
> We use PG 11.9 and are encountering the problem with connection
> limit and parallel workers aborting a totally valid query
> ("CONTEXT: parallel worker" error)
>
> I found there was a thread concerning this problem and even a
> patch was developed:
> https://www.postgresql.org/message-id/CAB7nPqQKJPgNkg0VQguUP1u%2BpDdk1qF16Qh5MtDQEtSMG4S-fg%40mail.gmail.com
> <https://www.postgresql.org/message-id/CAB7nPqQKJPgNkg0VQguUP1u%2BpDdk1qF16Qh5MtDQEtSMG4S-fg%40mail.gmail.com>
> but no news since 2017
>
> Do you know the status of the patch or a modification to remove
> the parallel worker from the connection count against user (also
> server?) CONNECTION_LIMIT or to just not launch workers if not
> possible?
>
>
> That thread was resolved with a committed patch [1] mid-thread, then
> got hijacked a bit...
>
> https://github.com/postgres/postgres/commit/f1169ab501ce90e035a7c6489013a1d4c250ac92
> <https://github.com/postgres/postgres/commit/f1169ab501ce90e035a7c6489013a1d4c250ac92>
>
> David J.
>

--
Martin Querleu - Directeur Général
EffiSYS (www.effitrace.fr - www.logistique-e-commerce.fr)
martin(dot)querleu(at)effisys(dot)fr
3, rue Gustave Delory
59000 Lille
Tél: +33 9 54 28 38 76

Vous rencontrez un problème d'utilisation sur effitr(at)ce?
=====> écrivez à support(at)effisys(dot)fr
Vous rencontrez un problème technique au niveau des échanges de données?
=====> écrivez à supervision(at)effisys(dot)fr