[DOC] Add detail regarding resource consumption wrt max_connections

From: Roberto Mello <roberto(dot)mello(at)gmail(dot)com>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [DOC] Add detail regarding resource consumption wrt max_connections
Date: 2023-11-13 21:40:08
Message-ID: CAKz==bJBCWrvN77fmuZ2XqD3jazWEb=E80AA4Yv9C9tQ61YDdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
max-connections-guc-detail.patch application/octet-stream 683 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Christensen 2023-11-13 21:53:18 Re: [PATCHES] Post-special page storage TDE support
Previous Message Tomas Vondra 2023-11-13 21:36:24 Re: Why do indexes and sorts use the database collation?