pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: EffiSYS / Martin Querleu <martin.querleu@effisys.fr>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: Update on
Date: Mon, 30 Nov 2020 10:04:30 +0100
Message-ID: <28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr> (raw)
In-Reply-To: <CAKFQuwZjQF3fmdTUqQ6nsZkDhN0azLvnn+Oecgvk7_7GcYoakw@mail.gmail.com>
References: <ec385de1-663b-4304-b288-4b225d0fd9a8@effisys.fr>
	<CAKFQuwZjQF3fmdTUqQ6nsZkDhN0azLvnn+Oecgvk7_7GcYoakw@mail.gmail.com>

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.querleu@effisys.fr <mailto:martin.querleu@effisys.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.g...
>     <https://www.postgresql.org/message-id/CAB7nPqQKJPgNkg0VQguUP1u%2BpDdk1qF16Qh5MtDQEtSMG4S-fg%40mail.g...;
>     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.querleu@effisys.fr
3, rue Gustave Delory
59000 Lille
Tél: +33 9 54 28 38 76

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

view thread (4+ messages)  latest in thread

Message-ID: <28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr>
Permalink:  ../28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr/
Also on:    postgresql.org/message-id/28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: martin.querleu@effisys.fr, david.g.johnston@gmail.com
  Subject: Re: Update on
  In-Reply-To: <28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr>
  References: <ec385de1-663b-4304-b288-4b225d0fd9a8@effisys.fr> <CAKFQuwZjQF3fmdTUqQ6nsZkDhN0azLvnn+Oecgvk7_7GcYoakw@mail.gmail.com> <28447d44-eafd-641f-c881-f1cd5c1f11e2@effisys.fr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox