Re: BUG #18094: max max_connections cannot be set

Поиск
Список
Период
Сортировка
От Nikolay Samokhvalov
Тема Re: BUG #18094: max max_connections cannot be set
Дата
Msg-id CANNMO+LUmkXtBR57on0a6qFtbJgjeoR56uan5Ru4BsW0TxbYjQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18094: max max_connections cannot be set  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #18094: max max_connections cannot be set  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
nik=# select max_val from pg_settings where name = 'max_connections';
 max_val
---------
 262143
(1 row)

-- here is why

On Thu, Sep 7, 2023 at 09:25 Tom Lane <tgl@sss.pgh.pa.us> wrote:
PG Bug reporting form <noreply@postgresql.org> writes:
> Expectation for max max_connections is 262143 in PG14, but it cannot be
> achieved:

Why do you think that's the maximum?

If you are looking at MAX_BACKENDS, that is not a limit on
max_connections.  It is a limit on max_connections +
autovacuum_max_workers + 1 + max_worker_processes + max_wal_senders;
cf check_max_connections.

                        regards, tom lane


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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18097: Immutable expression not allowed in generated at
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #18094: max max_connections cannot be set