Re: Update on

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Update on
Дата
Msg-id CAKFQuwZjQF3fmdTUqQ6nsZkDhN0azLvnn+Oecgvk7_7GcYoakw@mail.gmail.com
обсуждение исходный текст
Ответ на Update on  (EffiSYS / Martin Querleu <martin.querleu@effisys.fr>)
Ответы Re: Update on  (EffiSYS / Martin Querleu <martin.querleu@effisys.fr>)
Список pgsql-bugs
On Friday, November 27, 2020, EffiSYS / Martin Querleu <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.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...


David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: EffiSYS / Martin Querleu
Дата:
Сообщение: Update on
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16749: EXPLAIN only shows filtering from the first query in a union chain when using distinct on.