Re: shared memory settings

Поиск
Список
Период
Сортировка
От Devrim GÜNDÜZ
Тема Re: shared memory settings
Дата
Msg-id 1348657362.3516.61.camel@lenovo01-laptop03.gunduz.org
обсуждение исходный текст
Ответ на shared memory settings  (Alexander Shutyaev <shutyaev@gmail.com>)
Список pgsql-general
Hi,

On Wed, 2012-09-26 at 13:39 +0400, Alexander Shutyaev wrote:

> We need to increase max_connections to 3000. When we tried to do this
> we got an error

<snip>

Not an answer to your question but: Are you talking about 3k
*concurrent* connections? What are the server specs? I am not sure you
can handle that many connections, unless you are using HP DL 980 or  HP
Superdome or so.

You also may want to consider using connection pooler, namely pgbouncer.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Вложения

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

Предыдущее
От: Alexander Shutyaev
Дата:
Сообщение: shared memory settings
Следующее
От: Ryan Kelly
Дата:
Сообщение: PostgreSQL, OLAP, and Large Clusters