Groups > comp.databases.postgresql > #835

How to support more than 1200 client connections

Newsgroups	comp.databases.postgresql
Date	2018-08-02 01:46 -0700
Message-ID	<fe4f1abe-58e5-46cd-9ac9-c20648cf3d41@googlegroups.com> (permalink)
Subject	How to support more than 1200 client connections
From	Sachin Singh <notsachin@gmail.com>

Show all headers | View raw

Hi All,

In order to benchmark the API execution per second for our cloud product we want to test performance for 1200+ client connections and doing some operations. We are using postgres db in system of 32GB RAM. During the test execution after sometime we are seeing db crash because of out of memory issue.

We tried to use pgbouncer to resolve the issue but no luck. 

Do we have any solution to support the above requirement for 1 DB node. Or any configuration setting in pgbouncer which will help us.



Thanks
Sachin

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

How to support more than 1200 client connections Sachin Singh <notsachin@gmail.com> - 2018-08-02 01:46 -0700
  Re: How to support more than 1200 client connections Dimitri Fontaine <dim@tapoueh.org> - 2018-08-02 12:25 +0200
    Re: How to support more than 1200 client connections Sachin Singh <notsachin@gmail.com> - 2018-08-02 07:42 -0700
      Re: How to support more than 1200 client connections Dimitri Fontaine <dim@tapoueh.org> - 2018-08-02 17:32 +0200
  Re: How to support more than 1200 client connections George Neuner <gneuner2@comcast.net> - 2018-08-02 06:41 -0400
    Re: How to support more than 1200 client connections Sachin Singh <notsachin@gmail.com> - 2018-08-02 07:51 -0700

csiph-web