Re: remove check hooks for GUCs that contribute to MaxBackends

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2024-06-19T19:14:16Z
Lists: pgsql-hackers
Nathan Bossart <nathandbossart@gmail.com> writes:
> The attached patch removes these hooks and enhances the error message to
> look like this:

> 	FATAL:  too many backends configured
> 	DETAIL:  "max_connections" (262100) plus "autovacuum_max_workers" (3) plus "max_worker_processes" (8) plus "max_wal_senders" (10000) must be less than 262142.

BTW, I suggest writing it as "too many server processes configured",
or perhaps "too many server processes required".  "Backend" is too
much of an insider term.

			regards, tom lane



Commits

  1. Remove check hooks for GUCs that contribute to MaxBackends.