Re: postgres: dbname dbuser 9.9.9.9[2222] PARSE waiting

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Jun 27, 2017 at 3:41 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:

His problem is NOT 'idle in transaction' per se. It is all connections are used up.

Hence the need for pg_bouncer for connection pooling.

Whether pg_bouncer provides a viable solution is just as big an unknown as whether "idle in transaction" is the biggest contributor to the problem.  If all of them are idle in transaction then pg_bouncer is powerless to help.  If they are generally just long-lived sessions and only a few stay in transaction then transaction pooling mode may help.

David J.