Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 9.3 \(3124\))
Subject: Re: Connections Increasing Slowly
From: "Bee.Lists" <bee.lists@gmail.com>
In-Reply-To: <2088230.1592856708@sss.pgh.pa.us>
Date: Mon, 22 Jun 2020 21:57:44 -0400
Cc: Submit Postgresql Novice <pgsql-novice@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <0345AEA7-346C-452F-B3AE-13ED57818F5F@gmail.com>
References: <8A1234E2-D4C3-451F-8F60-901D0D5E0CA5@gmail.com>
 <2088230.1592856708@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Precedence: bulk

> On Jun 22, 2020, at 4:11 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> Postgres doesn't really think that killing connections is part of its
> charter.  (There is idle_in_transaction_session_timeout, but that's
> there to guard against a specific performance issue, not to kill
> non-misbehaving sessions.)
>=20
> You should probably think about putting a connection pooler such as
> pgbouncer in front of your server.  That's a better idea for lots of
> low-resource-demand clients than giving them direct server =
connections.
> And I think you're more likely to find features for killing idle
> connections there, too.
>=20
> Another idea, if you suspect that the idle connections are caused
> by firewall timeouts or the like, is to enable more aggressive
> TCP keepalive checking, to ensure the server notices if a client
> isn't there at all anymore.  See the tcp_keepalives_* settings.
>=20
> 			regards, tom lane

Hi Tom.

Who owns the actual connections?  The server allows them, the client =
requests them.  The error I am getting is that the gem I=E2=80=99m using =
uses a connection that=E2=80=99s dropped.  Actually I should say the =
=E2=80=9Cconnection pool=E2=80=9D.  The client doesn=E2=80=99t (the gem =
author doesn=E2=80=99t elaborate on any of this), and now you=E2=80=99re =
saying connections aren=E2=80=99t assumed by the database. =20

It=E2=80=99s been recommended that pg_stat_statements and =
pg_stat_activity to see what=E2=80=99s happening. =20


Cheers, Bee