| From: | EffiSYS / Martin Querleu <martin(dot)querleu(at)effisys(dot)fr> |
|---|---|
| To: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Update on |
| Date: | 2020-11-27 18:22:55 |
| Message-ID: | ec385de1-663b-4304-b288-4b225d0fd9a8@effisys.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
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?
Without that we'll have to configure a crazy number of user
connection_limit (not avoiding the problem but limiting the probability)
or remove parallel configuration, any of which would be a pity
Thanks in advance
Best regards
Martin
--
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2020-11-27 18:30:53 | Re: Update on |
| Previous Message | Tom Lane | 2020-11-27 17:37:45 | Re: SV: Problem with pg_notify / listen |