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 ) id 1ugLWB-001djb-6Q for pgpool-general@arkaria.postgresql.org; Mon, 28 Jul 2025 10:55:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ugLW7-006fHv-76 for pgpool-general@arkaria.postgresql.org; Mon, 28 Jul 2025 10:55:39 +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 ) id 1ugLW6-006fHn-WE for pgpool-general@lists.postgresql.org; Mon, 28 Jul 2025 10:55:39 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ugLW3-001Hgk-1o for pgpool-general@lists.postgresql.org; Mon, 28 Jul 2025 10:55:38 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=TciYzqKucIk5qurWmZF+K6ry+OjzQ2V0hn/+ExmNobM=; b=Z/n+HB0z6i9W3cGjFJQaE6UDyz GK0Cq8EJfPjeYzgGSCPH3ozb3dOF7zOF+Cl7qcibm0mzBoDpWxy5BdUxcjItf37SNdbxT9SKxjUKc OmZNwwTPDhkIM/kGCUcn5aTPRY/6X2gEn/v2zewHi5sOWoiDnqWLhqlWwx5na0f6RaKOq/+fIluUp hnq7/Yg16Swpr0WOQH2IvpLP22zlE27MVktjtIsDrRbzHdR47VewkGpKdqoNClNsK1IdGUP6Draps RlZYTKv3l39SclgU1wYMuiFPklU/YcdNNXEQCIbQwYyI4VuyuFKNdI8VvGHRQuCj/soNDq9e37F7a M4Lhkpww==; Received: from [2409:11:4120:300:1f27:922f:4c54:5b18] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256 (Exim 4.96) (envelope-from ) id 1ugLW1-0037ee-0C; Mon, 28 Jul 2025 10:55:36 +0000 Date: Mon, 28 Jul 2025 19:55:22 +0900 (JST) Message-Id: <20250728.195522.1634717277013819274.ishii@postgresql.org> To: r_suzuki@sjts.co.jp Cc: pgpool-general@lists.postgresql.org Subject: Re: Sudden increase in connections in pgpool usage environment From: Tatsuo Ishii In-Reply-To: <6c74ac0b-f943-4b27-ba7f-c6b3380faf4a@sjts.co.jp> References: <6c74ac0b-f943-4b27-ba7f-c6b3380faf4a@sjts.co.jp> X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=utf-8 Content-Transfer-Encoding: base64 X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:1f27:922f:4c54:5b18 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBIZWxsbywNCj4gVGhhbmsgeW91IGZvciBhbHdheXMgcHJvdmlkaW5nIHRoZSBjb252ZW5pZW50 IHBncG9vbCBzZXJ2aWNlLg0KPiBXZSByZWFsbHkgYXBwcmVjaWF0ZSBpdC4NCj4gKlRoaXMgZW1h aWwgd2FzIGNyZWF0ZWQgdXNpbmcgYXV0b21hdGljIHRyYW5zbGF0aW9uIGZyb20gSmFwYW5lc2Uu DQo+IA0KPiBBdCB0aGUgbW9tZW50LCB3ZSBoYXZlIG5vIGlkZWEgd2hhdCB0aGUgY2F1c2UgbWln aHQgYmUsDQo+IGJ1dCB3ZSBhcmUgZXhwZXJpZW5jaW5nIGEgc2VyaW91cyBpc3N1ZSBpbiB0aGUg ZW52aXJvbm1lbnQgd2hlcmUNCj4gcGdwb29sIGlzIHVzZWTigJQNCj4gc3VkZGVuIHNwaWtlcyBp biB0aGUgbnVtYmVyIG9mIGNvbm5lY3Rpb25zIHRvIFBvc3RncmVTUUwsIHdoaWNoIGlzDQo+IGNh dXNpbmcgdXMgZ3JlYXQgdHJvdWJsZS4NCj4gDQo+IFRoZSBlbnZpcm9ubWVudCBpcyBhcyBmb2xs b3dzOg0KPiANCj4gU2VydmVyIDE6IFRvbWNhdCAvIHBncG9vbCAoNC4yLjEpIC8gUG9zdGdyZVNR TCAoMTMuMTEpDQo+IFNlcnZlciAyOiBQb3N0Z3JlU1FMICgxMy4xMSkNCj4gDQo+IOKAoiBBIGN1 c3RvbS1idWlsdCB3ZWIgc3lzdGVtIGlzIHJ1bm5pbmcgb24gVG9tY2F0Lg0KPiDigKIgVGhlIG51 bWJlciBvZiBjb25uZWN0aW9ucyBmcm9tIFRvbWNhdCB0byBwZ3Bvb2wgaXMgY2FwcGVkIGF0IDMw MC4NCj4g4oCiIHBncG9vbCBpcyB1c2VkIHRvIHByb3ZpZGUgcmVkdW5kYW5jeSBiZXR3ZWVuIHRo ZSBQb3N0Z3JlU1FMIHNlcnZlcnMgb24NCj4g4oCiIFNlcnZlciAxIGFuZCBTZXJ2ZXIgMi4NCj4g 4oCiIFRoZXJlIGlzIG9ubHkgb25lIGRhdGFiYXNlIHJ1bm5pbmcgb24gUG9zdGdyZVNRTCwgYW5k IG9ubHkgb25lIHVzZXINCj4g4oCiIGNvbm5lY3RzIHRvIGl0Lg0KPiANCj4gSW4gdGhpcyBzZXR1 cCwgdGhlIG51bWJlciBvZiBjb25uZWN0aW9ucywgd2hpY2ggaXMgdXN1YWxseSBhcm91bmQgMjUs DQo+IHN1ZGRlbmx5IGluY3JlYXNlcyB0byAxMDAsIDIwMCwgYW5kIGV2ZW4gdXAgdG8gdGhlIG1h eGltdW0gb2YgMzAwIGluDQo+IGp1c3QgYSBmZXcgbWludXRlcy4NCj4gVGhpcyBwaGVub21lbm9u IG9jY3VycyBpcnJlZ3VsYXJseS4NCj4gDQo+IFdlIGluaXRpYWxseSBzdXNwZWN0ZWQgYW4gaXNz dWUgaW4gb3VyIGN1c3RvbSBzeXN0ZW0gYW5kIHJhbg0KPiBwZ19zdGF0X2FjdGl2aXR5IHRvIGNo ZWNrIHRoZSAicXVlcnkiIGNvbHVtbi4NCj4gSG93ZXZlciwgb25seSBhIGZldyBxdWVyaWVzIGFw cGVhcmVkIHRvIGJlIGlzc3VlZCBieSBvdXIgc3lzdGVtLg0KPiBNb3N0IG9mIHRoZSBlbnRyaWVz IHdlcmUgaW4gdGhlICJpZGxlIiBzdGF0ZSBhZnRlciBleGVjdXRpbmcgYQ0KPiAiRElTQ0FSRCBB TEwiIHF1ZXJ5Lg0KPiANCj4gV2Ugc3VzcGVjdCB0aGF0IHNvbWUgc2V0dGluZyBtaWdodCBiZSB0 cmlnZ2VyaW5nIGEgbWFzcyByZXNldCBvZg0KPiBjb25uZWN0aW9uLA0KPiBidXQgZHVlIHRvIG91 ciBsaW1pdGVkIGtub3dsZWRnZSwgd2UgYXJlIHN0cnVnZ2xpbmcgd2l0aCB0aGUNCj4gaW52ZXN0 aWdhdGlvbi4NCj4gV2UgYXBvbG9naXplIGZvciB0aGUgdHJvdWJsZSwgYnV0IGlmIHlvdSBoYXZl IGFueSBpbnNpZ2h0cywgd2Ugd291bGQNCj4gZ3JlYXRseSBhcHByZWNpYXRlIGl0Lg0KPiANCj4g DQo+IFdlIGFwb2xvZ2l6ZSBmb3IgdGhlIHRyb3VibGUsIGJ1dCBpZiB5b3UgaGF2ZSBhbnkgaWRl YSB3aGF0IG1pZ2h0IGJlDQo+IGhhcHBlbmluZywNCj4gd2Ugd291bGQgZ3JlYXRseSBhcHByZWNp YXRlIHlvdXIgaW5zaWdodC4NCg0KRmlyc3Qgb2YgYWxsLCBQZ3Bvb2wtSUkgNC4yLjEgaXMgcHJl dHR5IG9sZCAocmVsZWFzZWQgNSB5ZWFycyBhZ28pLg0KSXQgaGFzIGxvdHMgb2YgYnVncyBhbmQg ZXZlbiBtdWx0aXBsZSB2dWxuZXJhYmlsaXRpZXMuIEkgc3Ryb25nbHkNCnJlY29tbWVuZCB5b3Ug dG8gdXBncmFkZSB0byBuZXdlciB2ZXJzaW9uIG9mIFBncG9vbC1JSS4NCg0KPiBTZXJ2ZXIgMTog VG9tY2F0IC8gcGdwb29sICg0LjIuMSkgLyBQb3N0Z3JlU1FMICgxMy4xMSkNCg0KSXMgaXQgcG9z c2libGUgU2VydmVyMSBvdmVybG9hZGVkPyBJIGFtIGFza2luZyBiZWNhdXNlIG9uIHNlcnZlcjEg Mw0Ka2luZHMgb2Ygc2VydmVycyBhcmUgcnVubmluZy4gSSBzdXNwZWN0IHBncG9vbCBwcm9jZXNz IGFyZSBub3QgZW5vdWdoDQpDUFUgYmVpbmcgYXNzaWduZWQsIGFuZCBjYW5ub3QgZGlzcGF0Y2gg aW5jb21pbmcgbmV3IGNvbm5lY3Rpb25zLg0KDQpCZXN0IHJlZ2FyZHMsDQotLQ0KVGF0c3VvIElz aGlpDQpTUkEgT1NTIEsuSy4NCkVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4 X2VuLw0KSmFwYW5lc2U6aHR0cDovL3d3dy5zcmFvc3MuY28uanANCg==