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
signature.asc
Description: This is a digitally signed message part
