Re: Big number of connections - Mailing list pgsql-performance

From Chris Cogdon
Subject Re: Big number of connections
Date
Msg-id B2F62CE5-A0D5-4FBB-82B6-FB1EBBD81996@cogdon.org
Whole thread Raw
In response to Re: Big number of connections  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-performance
Although somewhat academic, since pgboucer doesn’t support it (and might not ever), have a look at this ticket which, if it was ever supported, would give you what you needed:



On Mar 31, 2016, at 15:47, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:

If they are going to keep the client connections open, they would need to
run pgbouncer in statement or transaction mode.

As I understand, in pgbouncer you cannot have connections that serve
different users.  If each individual requires its own database-level
user, pgbouncer would not help at all.

I would look seriously into getting rid of the always-open requirement
for connections.

— Chris Cogdon

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Big number of connections
Next
From: Karl Denninger
Date:
Subject: Re: Big number of connections