Groups > comp.databases.postgresql > #838

Re: How to support more than 1200 client connections

Newsgroups	comp.databases.postgresql
Date	2018-08-02 07:42 -0700
References	<fe4f1abe-58e5-46cd-9ac9-c20648cf3d41@googlegroups.com> <m2lg9p12w6.fsf@dimitris-macbook-pro.home>
Message-ID	<dac0ac74-b779-426e-a73a-1bc08218e7dc@googlegroups.com> (permalink)
Subject	Re: How to support more than 1200 client connections
From	Sachin Singh <notsachin@gmail.com>

Show all headers | View raw

On Thursday, August 2, 2018 at 3:55:30 PM UTC+5:30, Dimitri Fontaine wrote:
> Sachin Singh <notsachin@gmail.com> writes:
> > We tried to use pgbouncer to resolve the issue but no luck. 
> 
> Which pool_mode did you try? Have you read about the transation
> pool_mode yet, and decided if your application is compliant to this one?
> 
> -- 
> Dimitri Fontaine

With session pool_mode  out of memory error comes  and transaction mode not compliant with my application and with transaction mode my application is showing some errors

Looks like we need to go for postgreSQL cluster with load balancing.
Please let me know if you have some other suggestions
Sachin Singh

Back to comp.databases.postgresql | Previous | Next — Previous in thread | 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