Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1scH5A-005Y7P-Oy
	for pgsql-general@arkaria.postgresql.org; Fri, 09 Aug 2024 04:18:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1scH59-000zOA-4B
	for pgsql-general@arkaria.postgresql.org; Fri, 09 Aug 2024 04:18:27 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1scH58-000zO1-P9
	for pgsql-general@lists.postgresql.org; Fri, 09 Aug 2024 04:18:26 +0000
Received: from smtp74.iad3b.emailsrvr.com ([146.20.161.74])
	by magus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1scH56-003uD7-CO
	for pgsql-general@postgresql.org; Fri, 09 Aug 2024 04:18:26 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp18.relay.iad3b.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 44E56E0188;
	Fri,  9 Aug 2024 00:18:22 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Vacuum full connection exhaustion
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CANzqJaDZDLnYhPEds8jMf4ArEG1MOVtiPr7g0GvPMiEpjrNqiQ@mail.gmail.com>
Date: Thu, 8 Aug 2024 21:17:51 -0700
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <71219E8D-AD7F-4520-BD6F-975DA55D9DF4@thebuild.com>
References: <CAJ+5Ff6WtFCzamrRZqN3u3htvkGcmob7VaYWYBd+sRx6jKpHuA@mail.gmail.com>
 <66D17234-043D-457E-8607-5126B4FBC3DD@thebuild.com>
 <CANzqJaDZDLnYhPEds8jMf4ArEG1MOVtiPr7g0GvPMiEpjrNqiQ@mail.gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
X-Mailer: Apple Mail (2.3774.600.62)
X-Classification-ID: dad51d0b-2d89-4569-b2db-b8815fde6918-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/71219E8D-AD7F-4520-BD6F-975DA55D9DF4%40thebuild.com>
Precedence: bulk



> On Aug 8, 2024, at 21:15, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>=20
> "I see a lock, so let's cause another one!"  That's crazy.

It's more "Oh, look, I need a connection to service this web request, =
but my pool is empty, so I'll just fire up a new connection to the =
server," lather, rinse, repeat.  Pretty common these days, sadly.=