Re: postgresql 9.1 out of memory

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: postgresql 9.1 out of memory
Дата
Msg-id 1382815126520-5776018.post@n5.nabble.com
обсуждение исходный текст
Ответ на postgresql 9.1 out of memory  (Евгений Селявка <evg.selyavka@gmail.com>)
Список pgsql-admin
Two additional comments on your config:

max_connections = 350
Read up on connection poolers if you really think you need this many.
This inter-plays with work_mem due to concurrent processing effects.

max_prepared_transactions = 350
Really?  The default is zero and few people needs these...
I'm not sure if additional resources are consumed by this being enabled and
so large but the recommendation is to disable (leave at 0) this if you do
not use PREPARE TRANSACTION.

David J.







--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-9-1-out-of-memory-tp5776003p5776018.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postgresql 9.1 out of memory
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: postgresql 9.1 out of memory