[DOC] Add detail regarding resource consumption wrt max_connections

Поиск
Список
Период
Сортировка
От Roberto Mello
Тема [DOC] Add detail regarding resource consumption wrt max_connections
Дата
Msg-id CAKz==bJBCWrvN77fmuZ2XqD3jazWEb=E80AA4Yv9C9tQ61YDdQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: [DOC] Add detail regarding resource consumption wrt max_connections  (Cary Huang <cary.huang@highgo.ca>)
Список 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
Вложения

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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Why do indexes and sorts use the database collation?
Следующее
От: David Christensen
Дата:
Сообщение: Re: [PATCHES] Post-special page storage TDE support