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

On 06/27/2017 03:41 PM, Melvin Davidson wrote:
>
>
> On Tue, Jun 27, 2017 at 6:32 PM, Adrian Klaver

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

Not following. The 'idle in transaction' queries are coming in through a
connection so having them around is keeping a connection open. Dealing
with them will help with the connection count. Using pg_bouncer is an
option, but if you have a process that is not properly closing
transactions/connections you could get into an arms race between that
process and the size of your connection pool.

> *Hence the need for pg_bouncer for connection pooling.*
> --
> *Melvin Davidson*

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com