| From: | David Johnston <polobo(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: postgresql 9.1 out of memory |
| Date: | 2013-10-26 19:18:46 |
| Message-ID: | 1382815126520-5776018.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2013-10-26 19:48:54 | Re: postgresql 9.1 out of memory |
| Previous Message | Tom Lane | 2013-10-26 13:59:27 | Re: postgresql 9.1 out of memory |