Date: Sat, 26 Oct 2013 12:18:46 -0700 (PDT)
From: David Johnston <polobo@yahoo.com>
To: pgsql-admin@postgresql.org
Message-ID: <1382815126520-5776018.post@n5.nabble.com>
In-Reply-To: 
 <CAKPhvNY+LJV1MDTW=1KHX+igoUyyPVW8_V1-5+T18qBQ3CJGrw@mail.gmail.com>
References: 
 <CAKPhvNY+LJV1MDTW=1KHX+igoUyyPVW8_V1-5+T18qBQ3CJGrw@mail.gmail.com>
Subject: Re: postgresql 9.1 out of memory
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


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.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin