Increasing maximum connection for postgresql 9.2

From: Amardeep Kaur <amardeepkaur88(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Increasing maximum connection for postgresql 9.2
Date: 2014-02-21 02:35:00
Message-ID: CAJ1JmhVa5d-3YUZLWYgv9s_AoBVsVxzGcLB8ut_i3Xkz7g-=nA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey Guys

I am trying to increase the max_connection from 100 to 5000. I modified
shared_buffer and changed kernel parameters according to
http://www.postgresql.org/docs/9.2/static/kernel-resources.html#SYSVIPC.
When i stress test it with 500 concurrent request, then after 150 - 160
concurrent connections my database enters into recovery mode and it fails
the request. For my stress test i am trying to get data from one table.
Do you guys have any idea what is causing the problem or if i am missing
some other configuration?

--
Amardeep Kaur

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2014-02-21 03:34:17 Re: Increasing maximum connection for postgresql 9.2
Previous Message Mel Llaguno 2014-02-19 18:05:54 Re: Availability of parallel jobs option in pg_dumpall