Re: [DOC] Add detail regarding resource consumption wrt max_connections

Поиск
Список
Период
Сортировка
От Cary Huang
Тема Re: [DOC] Add detail regarding resource consumption wrt max_connections
Дата
Msg-id 170509767861.1131.15083983626399995184.pgcf@coridan.postgresql.org
обсуждение исходный текст
Ответ на [DOC] Add detail regarding resource consumption wrt max_connections  (Roberto Mello <roberto.mello@gmail.com>)
Ответы Re: [DOC] Add detail regarding resource consumption wrt max_connections  (Roberto Mello <roberto.mello@gmail.com>)
Re: [DOC] Add detail regarding resource consumption wrt max_connections  (Michael Banck <mbanck@gmx.net>)
Список pgsql-hackers
The following review has been posted through the commitfest application:
make installcheck-world:  tested, passed
Implements feature:       tested, passed
Spec compliant:           tested, passed
Documentation:            tested, passed

I think it is good to warn the user about the increased allocation of memory for certain parameters so that they do not
abuseit by setting it to a huge number without knowing the consequences.
 

It is true that max_connections can increase the size of proc array and other resources, which are allocated in the
sharedbuffer, which also means less shared buffer to perform regular data operations. I am sure this is not the only
parameterthat affects the memory allocation. "max_prepared_xacts" can also affect the shared memory allocation too so
thesame warning message applies here as well. Maybe there are other parameters with similar effects. 
 

Instead of stating that higher max_connections results in higher allocation, It may be better to tell the user that if
thevalue needs to be set much higher, consider increasing the "shared_buffers" setting as well.
 

thank you

-----------------------
Cary Huang
Highgo Software Canada
www.highgo.ca

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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Make NUM_XLOGINSERT_LOCKS configurable
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: pg_upgrade failing for 200+ million Large Objects