| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | Alexander Shutyaev <shutyaev(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: shared memory settings |
| Date: | 2012-09-26 11:02:42 |
| Message-ID: | 1348657362.3516.61.camel@lenovo01-laptop03.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryan Kelly | 2012-09-26 11:50:44 | PostgreSQL, OLAP, and Large Clusters |
| Previous Message | Yelai, Ramkumar IN BLR STS | 2012-09-26 10:05:05 | Re: Need help in reclaiming disk space by deleting the selected records |