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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> PG Bug reporting form <noreply(at)postgresql(dot)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
>
>
>