Groups > comp.databases.postgresql > #835

How to support more than 1200 client connections

X-Received	by 2002:a37:4a49:: with SMTP id x70-v6mr937941qka.60.1533199587359; Thu, 02 Aug 2018 01:46:27 -0700 (PDT)
X-Received	by 2002:a81:330a:: with SMTP id z10-v6mr38438ywz.5.1533199587182; Thu, 02 Aug 2018 01:46:27 -0700 (PDT)
Path	csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!e8-v6no201782qtp.0!news-out.google.com!g23-v6ni69qtp.0!nntp.google.com!e8-v6no201779qtp.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.postgresql
Date	Thu, 2 Aug 2018 01:46:26 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=103.19.212.1; posting-account=GPVSKQoAAAAPZsRLSYRJXZFVrfw4KP33
NNTP-Posting-Host	103.19.212.1
User-Agent	G2/1.0
MIME-Version	1.0
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>
Injection-Date	Thu, 02 Aug 2018 08:46:27 +0000
Content-Type	text/plain; charset="UTF-8"
Content-Transfer-Encoding	quoted-printable
Lines	15
Xref	csiph.com comp.databases.postgresql:835

Show key headers only | 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