Parameters to consider on increasing max_connections and physical memory

Поиск
Список
Период
Сортировка
От Gnanakumar
Тема Parameters to consider on increasing max_connections and physical memory
Дата
Msg-id 004d01ccdb1f$06f8cea0$14ea6be0$@com
обсуждение исходный текст
Ответы Re: Parameters to consider on increasing max_connections and physical memory
Список pgsql-admin
Hi,

Our Production server is running PostgreSQL v8.2.22 on CentOS5.2.  Based on
the application usage trend, we're finding that we need to increase maximum
number of concurrent connections to the database server, that is
"max_connections" parameter.  Of course, I also understand that it requires
more system physical memory.

My question is, what are all the PostgreSQL conf parameters that I must take
into account/consider to adjust/modify, if we increase system physical
memory and "max_connections"?

Regards,
Gnanam



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: two questions regarding warm-standby on 8.4
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Parameters to consider on increasing max_connections and physical memory