Re: postgresql 9.1 out of memory - Mailing list pgsql-admin

From David Johnston
Subject Re: postgresql 9.1 out of memory
Date
Msg-id 1382815126520-5776018.post@n5.nabble.com
Whole thread Raw
In response to postgresql 9.1 out of memory  (Евгений Селявка <evg.selyavka@gmail.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql 9.1 out of memory
Next
From: Stephen Frost
Date:
Subject: Re: postgresql 9.1 out of memory