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 1umM22-00ECnU-Iw for pgpool-general@arkaria.postgresql.org; Thu, 14 Aug 2025 00:41:26 +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 1umM20-001XX2-HF for pgpool-general@arkaria.postgresql.org; Thu, 14 Aug 2025 00:41:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1umM1z-001XWu-VU for pgpool-general@lists.postgresql.org; Thu, 14 Aug 2025 00:41:24 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1umM1w-000S5H-22 for pgpool-general@lists.postgresql.org; Thu, 14 Aug 2025 00:41:23 +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=hTDFwFOh8gWH/Nfu/PYuEPz/Vob1Z52EfKsG2qj42fM=; b=F4zbNyD3vSQ9qvY5dbkfblg19l MNA1/ld9BsVYWk55X/HWszWTLrnt6RIhsDypi0T530dG+mKh6J2dyTmvZnStOumc9h694unB5yYm3 CirZm7A+vLYy2jMGu3b9flbsoAZ5hZpNk43eav4/RS64S0vKuEsn0YvPgwdloo277J60TFBaquXIx 5Z0cm5sMPbu+adbMc8tHH8C4tIU26aSy1S7cQWWWukmo+KZF9WNiacBTjdp6El9pushjDWhq1/JWN 7wjD25in9lKxcB0X84cPIG1FVEDjF/XYnYlBpIR87YyinOs88DNixpzIMMy35Wf2Lp4yUPN8RQZAP IQ9OA/Bg==; Received: from [2409:11:4120:300:e8d6:17ae:4d9:282e] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256 (Exim 4.96) (envelope-from ) id 1umM1s-0017UQ-3C; Thu, 14 Aug 2025 00:41:20 +0000 Date: Thu, 14 Aug 2025 09:41:06 +0900 (JST) Message-Id: <20250814.094106.616667391663958437.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: <67937db4-a681-4e28-adcc-da6b02e9964f@sjts.co.jp> References: <20250730.211324.1175750923831808216.ishii@postgresql.org> <67937db4-a681-4e28-adcc-da6b02e9964f@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:e8d6:17ae:4d9:282e (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk U29ycnkgZm9yIGxhdGUgcmVwbHkuDQoNCj4+IFdoYXQgZG8geW91IG1lYW4gYnkgImV2ZW4gaWYg YSBjb25uZWN0aW9uIGlzIG5vdCBleHBsaWNpdGx5IG5lZWRlZCI/DQo+PiBDYW4geW91IGVsYWJv cmF0ZSBtb3JlPw0KPiANCj4gSSBhcG9sb2dpemUgaWYgbXkgcHJldmlvdXMgZXhwbGFuYXRpb24g d2FzIHVuY2xlYXIuDQo+IFdoYXQgSSB3b3VsZCBsaWtlIHRvIGNvbmZpcm0gaXMgdGhpczoNCj4g RXZlbiBpZiB0aGUgd2ViIHNlcnZpY2UgaXRzZWxmIGRvZXMgbm90IGV4cGxpY2l0bHkgaW5pdGlh dGUgYW55DQo+IGRhdGFiYXNlIGNvbm5lY3Rpb25zLA0KPiBpcyB0aGVyZSBhbnkgc2l0dWF0aW9u IHdoZXJlIHBncG9vbCBtaWdodCBhdHRlbXB0IHRvIGNvbm5lY3QgdG8NCj4gUG9zdGdyZVNRTCBv biBpdHMgb3duPw0KDQpOby4NCg0KPj4gRm9yIHBncG9vbCBUbyBjcmVhdGUgMzAwIGNvbm5lY3Rp b25zIHRvIFBvc3RncmVTUUwsIHlvdSBkb24ndCBuZWVkIHRvDQo+PiBoYXZlIDMwMCB3ZWIgY29u bmVjdGlvbnMgZXhhY3RseSBhdCB0aGUgc2FtZSB0aW1pbmcuDQo+IA0KPiBGb3IgZXhhbXBsZSwg c3VwcG9zZSB0aGUgbWF4aW11bSBudW1iZXIgb2YgY29ubmVjdGlvbnMgZnJvbSBUb21jYXQgdG8N Cj4gcGdwb29sIGlzIDMwMCwNCj4gYW5kIHRoZSBudW1faW5pdF9jaGlsZHJlbiBwYXJhbWV0ZXIg aW4gcGdwb29sIGlzIHNldCB0byA2MDAgKHdpdGgNCj4gbWF4X3Bvb2wgc2V0IHRvIDEpLg0KPiAN Cj4gSW4gdGhpcyBjYXNlLCBldmVuIGlmIHBncG9vbCBhbHJlYWR5IGhvbGRzIDMwMCBjb25uZWN0 aW9ucyB0bw0KPiBQb3N0Z3JlU1FMLA0KPiBpcyBpdCBwb3NzaWJsZSDigJQgaWYgdGhlIGNpcmN1 bXN0YW5jZXMgYXJlIHVuZmF2b3JhYmxlIOKAlA0KPiB0aGF0IHRoZSByZW1haW5pbmcgMzAwIGNo aWxkIHByb2Nlc3NlcyBjb3VsZCBhbHNvIGVuZCB1cCBlc3RhYmxpc2hpbmcNCj4gY29ubmVjdGlv bnMsDQo+IHJlc3VsdGluZyBpbiBhIHRvdGFsIG9mIHVwIHRvIDYwMCBjb25uZWN0aW9ucyB0byBQ b3N0Z3JlU1FMPw0KDQpZZXMuIFN1cHBvc2UgcGdwb29sIGFscmVhZHkgaGFzIDMwMCBjb25uZWN0 aW9ucyB0byBQb3N0Z3JlU1FMLCB0aGVuDQpuZXcgY29ubmVjdGlvbiByZXF1ZXN0IGZyb20gY2xp ZW50IGFycnZpZXMuIElmIGFsbCAzMDAgcGdwb29sIGNoaWxkDQpwcm9jZXNzIGhhdmUgY29ubmVj dGlvbnMgZnJvbSBjbGllbnRzICh0aHVzIG5vdCBpbiAid2FpdGluZyBmb3INCmNvbm5lY3Rpb24g cmVxdWVzdCIgc3RhdGUpLCB0aGVuIHRoZSBrZXJuZWwgd2FrZXMgdXAgYSBwZ3Bvb2wgY2hpbGQN CnByb2Nlc3Mgd2hpY2ggaXMgaW4gIndhaXRpbmcgZm9yIGNvbm5lY3Rpb24gcmVxdWVzdCIgc3Rh dGUgYW5kIGxldCBpdA0KaGFuZGxlIHRoZSBpbmNvbWluZyBjb25uZWN0aW9uLiBJZiB0aGUgcHJv Y2VzcyBkb2VzIG5vdCBoYXZlIGENCmNvbm5lY3Rpb24gcG9vbCB0byBQb3N0Z3JlU1FMLCB0aGVu IHRoZSBjaGlsZCBwcm9jZXNzIHdpbGwgY3JlYXRlIGENCm5ldyBjb25uZWN0aW9uIHRvIFBvc3Rn cmVTUUwuIFRoaXMgY291bGQgY29udGludWUgdW50aWwgYWxsIDYwMA0KIndhaXRpbmcgZm9yIGNv bm5lY3Rpb24gcmVxdWVzdCIgc3RhdGUgcHJvY2VzcyBhcmUgaW4gdXNlLg0KDQo+IEFsc28sIGlz IGl0IGNvcnJlY3QgdG8gdW5kZXJzdGFuZCB0aGF0IGluIG9yZGVyIHRvIG1pdGlnYXRlIHRoaXMN Cj4gc2l0dWF0aW9uLA0KPiBpdCBpcyBhZHZpc2FibGUgdG8gdXNlIHNldHRpbmdzIHN1Y2ggYXMg Y2xpZW50X2lkbGVfbGltaXQgdG8NCj4gYXBwcm9wcmlhdGVseSBkaXNjYXJkIHVudXNlZCBjb25u ZWN0aW9ucz8NCj4gDQo+IEkgd291bGQgZ3JlYXRseSBhcHByZWNpYXRlIGl0IGlmIHlvdSBjb3Vs ZCBraW5kbHkgcHJvdmlkZSB5b3VyDQo+IHJlc3BvbnNlLg0KDQpJZiB5b3Ugd2FudCB0byBkZWNy ZWFzZSB0aGUgbnVtYmVyIG9mIGNvbm5lY3Rpb25zIGZyb20gcGdwb29sIHRvDQpQb3N0Z3JlU1FM LCB5b3UgY291bGQgc2V0IGxvd2VyIG51bWJlciB0byBudW1faW5pdF9jaGlsZHJlbi4NCg0KSWYg eW91IGRvIG5vdCB3YW50IHRvIGxvd2VyIG51bV9pbml0X2NoaWxkcmVuLCB5b3Ugc2hvdWxkIGNv bnNpZGVyDQp0byB0d2VhayBmb2xsb3dpbmcgcGFyYW1ldGVyczoNCg0KY29ubmVjdGlvbl9saWZl X3RpbWUNCmNsaWVudF9pZGxlX2xpbWl0DQpjaGlsZF9saWZlX3RpbWUNCmNoaWxkX21heF9jb25u ZWN0aW9ucw0KDQpCVFcsIHlvdSBhcmUgdXNpbmcgVG9tY2F0LiBJcyBpdCBwb3NzaWJsZSB0aGF0 IFRvbWNhdCBrZWVwcyBjb25uZWN0aW9uDQp0byBwZ3Bvb2w/IEkgYW0gYXNraW5nIGJlY2F1c2Ug SSBhbSBub3QgZmFtaWxpYXIgd2l0aCBUb21jYXQuIElmIHNvLA0KcGdwb29sIG1heSBmYWlsIHRv IG1hbmFnZSBjb25uZWN0aW9uIHBvb2xpbmcgYmVjYXVzZSBpdCBkb2VzIG5vdCBoYXZlDQphbiBv cHBvdHVuaXR5IHRvIHJlbGVhc2UgY29ubmVjdGlvbnMgdG8gUG9zdGdyZVNRTCBldmVuIGlmIHRo ZQ0KcGFyYW1ldGVycyBhYm92ZSBhcmUgc2V0Lg0KDQo+IE9uIDIwMjUvMDcvMzAgMjE6MTMsIFRh dHN1byBJc2hpaSB3cm90ZToNCj4+Pj4gSXMgaXQgcG9zc2libGUgU2VydmVyMSBvdmVybG9hZGVk PyBJIGFtIGFza2luZyBiZWNhdXNlIG9uIHNlcnZlcjEgMw0KPj4+PiBraW5kcyBvZiBzZXJ2ZXJz IGFyZSBydW5uaW5nLiBJIHN1c3BlY3QgcGdwb29sIHByb2Nlc3MgYXJlIG5vdCBlbm91Z2gNCj4+ Pj4gQ1BVIGJlaW5nIGFzc2lnbmVkLCBhbmQgY2Fubm90IGRpc3BhdGNoIGluY29taW5nIG5ldyBj b25uZWN0aW9ucy4NCj4+Pg0KPj4+IFVuZGVyIG5vcm1hbCBjb25kaXRpb25zLCB0aGUgc2VydmVy IGxvYWQgaXMgbm90IHBhcnRpY3VsYXJseQ0KPj4+IHByb2JsZW1hdGljLg0KPj4+IFJhdGhlciwg aXQgc2VlbXMgdGhhdCB0aGUgbG9hZCBpbmNyZWFzZXMgYXQgdGhlIHNhbWUgdGltZSB0aGUgIkRJ U0NBUkQNCj4+PiBBTEwiIG9jY3Vycy4NCj4+Pg0KPj4+IFJlZ2FyZGluZyB0aGUgcGhyYXNlICJj YW5ub3QgZGlzcGF0Y2ggaW5jb21pbmcgbmV3IGNvbm5lY3Rpb25zLCINCj4+PiBJIHdhcyB3b25k ZXJpbmfigJVkb2VzIHBncG9vbCBzb21ldGltZXMgZXN0YWJsaXNoIGNvbm5lY3Rpb25zIHRvDQo+ Pj4gUG9zdGdyZVNRTCBhdXRvbWF0aWNhbGx5LA0KPj4+IGV2ZW4gaWYgYSBjb25uZWN0aW9uIGlz IG5vdCBleHBsaWNpdGx5IG5lZWRlZD8NCj4+IFdoYXQgZG8geW91IG1lYW4gYnkgImV2ZW4gaWYg YSBjb25uZWN0aW9uIGlzIG5vdCBleHBsaWNpdGx5IG5lZWRlZCI/DQo+PiBDYW4geW91IGVsYWJv cmF0ZSBtb3JlPw0KPj4gDQo+Pj4gTXkgY3VycmVudCB1bmRlcnN0YW5kaW5nIGlzIHRoYXQgYSBj b25uZWN0aW9uIHRvIFBvc3RncmVTUUwgaXMgY3JlYXRlZA0KPj4+IG9ubHkgd2hlbiBUb21jYXQg bWFrZXMgYSByZXF1ZXN0IGZvciBvbmUsDQo+Pj4gYW5kIHRoYXQgcGdwb29sIGluaXRpYXRlcyB0 aGUgY29ubmVjdGlvbiBhdCB0aGF0IHBvaW50Lg0KPj4gWWVzLg0KPj4gDQo+Pj4gU2luY2UgaXTi gJlzIGEgYml0IGhhcmQgdG8gaW1hZ2luZSB0aGUgd2ViIHN5c3RlbSBzdWRkZW5seSB1c2luZyB1 cCBhcw0KPj4+IG1hbnkgYXMgMzAwIGNvbm5lY3Rpb25zIGFsbCBhdCBvbmNlLA0KPj4+IEkganVz dCB3YW50ZWQgdG8gY2hlY2sgYW5kIG1ha2Ugc3VyZSBJ4oCZbSBub3QgbWlzdW5kZXJzdGFuZGlu ZyBob3cNCj4+PiB0aGlzIHdvcmtzLg0KPj4gRm9yIHBncG9vbCBUbyBjcmVhdGUgMzAwIGNvbm5l Y3Rpb25zIHRvIFBvc3RncmVTUUwsIHlvdSBkb24ndCBuZWVkIHRvDQo+PiBoYXZlIDMwMCB3ZWIg Y29ubmVjdGlvbnMgZXhhY3RseSBhdCB0aGUgc2FtZSB0aW1pbmcuDQo+PiBXaGVuIGEgY2xpZW50 IGNvbm5lY3RzIHBncG9vbCwgb25lIG9mIHBncG9vbCAiY2hpbGQiIHByb2Nlc3MgaXMgY2hvc2Vu DQo+PiBieSBrZXJuZWwuIElmIHRoZSBwcm9jZXNzIGFscmVhZHkgaGF2ZSBhIHN1aXRhYmxlIGNv bm5lY3Rpb25zIGNhY2hlDQo+PiAoaS5lLiBtYXRjaGVzIHRoZSByZXF1ZXN0ZWQgdXNlcm5hbWUv ZGF0YWJhc2UgZXRjLiksIG5vIG5ldyBjb25uZWN0aW9uDQo+PiB0byBQb3N0Z3JlU1FMIGlzIGNy ZWF0ZWQuIEhvd2V2ZXIgdGhlIHByb2Nlc3MgZG9lcyBub3QgaGF2ZSwgYSBuZXcNCj4+IGNvbm5l Y3Rpb24gdG8gUG9zdGdyZVNRTCBpcyBjcmVhdGVkLiBTaW5jZSBrZXJuZWwgZG9lcyBub3QgY2Fy ZQ0KPj4gd2hldGhlciB0aGUgcGFydGljdWxhciBwZ3Bvb2wgcHJvY2VzcyBhbHJlYWR5IGhhcyB0 aGUgcmVxdWVzdGVkDQo+PiBjb25uZWN0aW9uIHRvIFBvc3RncmVTUUwsIGl0IGlzIHBvc3NpYmxl IHRoYXQgYSBwZ3Bvb2wgcHJvY2VzcyB3aGljaA0KPj4gZG9lcyBub3QgaGF2ZSB0aGUgY29ubmVj dGlvbi4gU28gaWYgeW91IGFyZSB1bmx1Y2t5LCBjb250aW51b3VzIGEgZmV3DQo+PiBudW1iZXIg b2YgY29uY3VycmVudCByZXF1ZXN0cyBmcm9tIGNsaWVudHMgY291bGQgbWFrZSBhbGwgMzAwIHBn cG9vbA0KPj4gcHJvY2VzcyBjb25uZWN0IHRvIFBvc3RncmVTUUwuDQo+PiBUbyBkZWFsIHdpdGgg dGhlIHNpdHVhdGlvbiwgeW91IGNhbiB0d2VhayBjb25maWd1cmF0aW9ucyBpbiAiLSBMaWZlDQo+ PiB0aW1lIC0iIHNlY3Rpb24gb2YgcGdwb29sLmNvbmYuIFNlZSB0aGUgbWFudWFsIGZvciBtb3Jl IGRldGFpbHMuDQo+PiBCZXN0IHJlZ2FyZHMsDQo+PiAtLQ0KPj4gVGF0c3VvIElzaGlpDQo+PiBT UkEgT1NTIEsuSy4NCj4+IEVuZ2xpc2g6IGh0dHA6Ly93d3cuc3Jhb3NzLmNvLmpwL2luZGV4X2Vu Lw0KPj4gSmFwYW5lc2U6aHR0cDovL3d3dy5zcmFvc3MuY28uanANCj4gDQo+IA0KPiANCg==