[DOC] Add detail regarding resource consumption wrt max_connections
Roberto Mello <roberto.mello@gmail.com>
From: Roberto Mello <roberto.mello@gmail.com>
To: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2023-11-13T21:40:08Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Document that increasing max_connections uses more resources.
- 8ba346283335 17.0 landed
Attachments
- max-connections-guc-detail.patch (application/octet-stream) patch
The documentation for max_connections does not mention that just by having
a higher value for max_connections, PostgreSQL will use more resources.
While working with different customers, I noticed that several of them set
max_connections to very high numbers, even though they never expected to
actually have that many connections to their PostgreSQL instance.
In one extreme case, the user set max_connections to 200000 and was
befuddled that the instance was using more memory than another with the
same number of connections.
This patch adds language to the documentation pointing to the fact that
higher value of max_connections leads to higher consumption of resources by
Postgres, adding one paragraph to doc/src/sgml/config.sgml
<para>
PostgreSQL sizes certain resources based directly on the value of
<varname>max_connections</varname>. Increasing its value leads to
higher allocation of those resources, including shared memory.
</para>
Sincerely,
Roberto Mello