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 1tFaDL-00E2Mm-6o for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Nov 2024 14:37:23 +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 1tFaDJ-00FZDK-Rb for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Nov 2024 14:37:21 +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 1tFYBI-00EuwO-JK for pgsql-bugs@lists.postgresql.org; Mon, 25 Nov 2024 12:27:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFYBF-003lYf-Vn for pgsql-bugs@lists.postgresql.org; Mon, 25 Nov 2024 12:27:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=uhlu7WiY2bqk4WKXvyxFtpnp8g+/si01LXdDVfDa4XM=; b=Hli1NNR8GBsrv7U8RUWcgL0nM7 pSbiy2t+xWM/PdzccGWqmP3lblYr18tylmvxSXGpCKgKjTSZHnpmJz+abQB+UmVdazNKbhOUQbb0X dlPSDwkRB6YGCr1yXgrmihMswv8Y0hCHyJqFA3FGTestIWBNp+orILtQ9zs7s4VjbaZJcXv1jcZhQ bfylI+o8jxRPU3R1dssZmK36dGYdtxFKmzTBc2f1w8piqOt3wmDlXKvpHuf2GHBRkkcHimKirZmwK gp9Lj2jUt6brHtHyJ++Eyf2Mn0DM5BxGLoguDxTc7GLBtkkETpeNxuafk2zrfsJktumKCPlplAFkg sF47L5sQ==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFYBD-00BYRP-W2 for pgsql-bugs@lists.postgresql.org; Mon, 25 Nov 2024 12:27:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tFYBC-00HNNQ-Gb for pgsql-bugs@lists.postgresql.org; Mon, 25 Nov 2024 12:27:02 +0000 Content-Type: multipart/mixed; boundary="===============6510813755504783712==" MIME-Version: 1.0 Subject: BUG #18724: High data disk utilization during log writing To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sit7602@gmail.com Reply-To: sit7602@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 25 Nov 2024 12:26:52 +0000 Message-ID: <18724-1715b6dccdce4624@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6510813755504783712== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODcyNApMb2dnZWQgYnk6ICAgICAgICAgIFNpdG5pa292IEl2YW4KRW1h aWwgYWRkcmVzczogICAgICBzaXQ3NjAyQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE2 LjQKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjQuMDQuMSBMVFMKRGVzY3JpcHRpb246ICAg ICAgICAKClRoZXJlIGlzIGEgcHJvYmxlbSB3aXRoIGhpZ2ggbG9hZCBvbiB0aGUgZGF0YSBkaXNr IHdpdGggcXVlcnkgbG9ncyBlbmFibGVkCihsb2dfbWluX2R1cmF0aW9uX3N0YXRlbWVudCA9IDAp LCBwcm92aWRlZCB0aGF0IHRoZSBsb2cgZmlsZSBpcyBvbiBhCnNlcGFyYXRlIGRpc2suDQoNCkkg d2FudCB0byBjbGFyaWZ5IHRoYXQgdGhlIHNlcnZlciBzZXR1cCBsb29rcyBsaWtlIHRoaXM6DQoN Ci9kZXYvdmRhMSAvIC0gU3lzdGVtIGRpc2sgLSBzb3VyY2Ugc3lzdGVtIHBhY2thZ2VzIGFuZCB1 dGlsaXRpZXMgKGluY2x1ZGluZwpwb3N0Z3JlcykNCi9kZXYvdmRiMSAvZGF0YSAtIERhdGEgZGlz ayAtIGEgc2VwYXJhdGUgZGlzayBmb3Igc3RvcmluZyBkYXRhDQovZGV2L3ZkYzEgL3Zhci9sb2cv cG9zdGdyZXNxbCAtIExvZyBkaXNrIC0gbW91bnRlZCBvbiB0aGUKL3Zhci9sb2cvcG9zdGdyZXNx bCBmb2xkZXINCi9kZXYvdmRkMSAvd2FsX2RhdGEgLSBEaXNrIGZvciB3YWwgZmlsZXMgLSBhIHN5 bWxpbmsgZm9yIHBnX3dhbA0KDQpQb3N0Z3Jlc3FsIGNvbmZpZyBpcyBsaXN0ZWQgYmVsb3c6DQpk YXRhX2RpcmVjdG9yeSA9ICcvZGF0YS9wb3N0Z3Jlc3FsLzE2L21haW4vbWFpbicJCSMgdXNlIGRh dGEgaW4gYW5vdGhlcgpkaXJlY3RvcnkNCmhiYV9maWxlID0gJy9ldGMvcG9zdGdyZXNxbC8xNi9t YWluL3BnX2hiYS5jb25mJwkjIGhvc3QtYmFzZWQgYXV0aGVudGljYXRpb24KZmlsZQ0KaWRlbnRf ZmlsZSA9ICcvZXRjL3Bvc3RncmVzcWwvMTYvbWFpbi9wZ19pZGVudC5jb25mJwkjIGlkZW50IGNv bmZpZ3VyYXRpb24KZmlsZQ0KDQojIElmIGV4dGVybmFsX3BpZF9maWxlIGlzIG5vdCBleHBsaWNp dGx5IHNldCwgbm8gZXh0cmEgUElEIGZpbGUgaXMKd3JpdHRlbi4NCmV4dGVybmFsX3BpZF9maWxl ID0gJy92YXIvcnVuL3Bvc3RncmVzcWwvMTYtbWFpbi5waWQnCQkJIyB3cml0ZSBhbiBleHRyYSBQ SUQKZmlsZQ0KDQpsaXN0ZW5fYWRkcmVzc2VzID0gJyonCQkJIyB3aGF0IElQIGFkZHJlc3MoZXMp IHRvIGxpc3RlbiBvbjsNCnBvcnQgPSA1NDMyCQkJCSMgKGNoYW5nZSByZXF1aXJlcyByZXN0YXJ0 KQ0KbWF4X2Nvbm5lY3Rpb25zID0gNTAwCQkJIyAoY2hhbmdlIHJlcXVpcmVzIHJlc3RhcnQpDQp1 bml4X3NvY2tldF9kaXJlY3RvcmllcyA9ICcvdmFyL3J1bi9wb3N0Z3Jlc3FsJwkjIGNvbW1hLXNl cGFyYXRlZCBsaXN0IG9mCmRpcmVjdG9yaWVzDQoNCnNzbCA9IG9uDQoNCnNoYXJlZF9idWZmZXJz ID0gMzJHQgkJCSMgbWluIDEyOGtCDQoNCndvcmtfbWVtID0gMjYyMTQ0a0IJCQkjIG1pbiA2NGtC DQptYWludGVuYW5jZV93b3JrX21lbSA9IDgxOTJNQgkJIyBtaW4gMU1CDQoNCmR5bmFtaWNfc2hh cmVkX21lbW9yeV90eXBlID0gcG9zaXgJIyB0aGUgZGVmYXVsdCBpcyB0aGUgZmlyc3Qgb3B0aW9u DQoNCg0KZWZmZWN0aXZlX2lvX2NvbmN1cnJlbmN5ID0gMgkJIyAxLTEwMDA7IDAgZGlzYWJsZXMg cHJlZmV0Y2hpbmcNCm1heF93b3JrZXJfcHJvY2Vzc2VzID0gOAkJIyAoY2hhbmdlIHJlcXVpcmVz IHJlc3RhcnQpDQptYXhfcGFyYWxsZWxfbWFpbnRlbmFuY2Vfd29ya2VycyA9IDIJIyB0YWtlbiBm cm9tIG1heF9wYXJhbGxlbF93b3JrZXJzDQptYXhfcGFyYWxsZWxfd29ya2Vyc19wZXJfZ2F0aGVy ID0gMgkjIHRha2VuIGZyb20gbWF4X3BhcmFsbGVsX3dvcmtlcnMNCm1heF9wYXJhbGxlbF93b3Jr ZXJzID0gOAkJIyBtYXhpbXVtIG51bWJlciBvZiBtYXhfd29ya2VyX3Byb2Nlc3NlcyB0aGF0DQoN CndhbF9sZXZlbCA9IHJlcGxpY2EJCQkjIG1pbmltYWwsIHJlcGxpY2EsIG9yIGxvZ2ljYWwNCg0K d2FsX2J1ZmZlcnMgPSAxNk1CCQkJIyBtaW4gMzJrQiwgLTEgc2V0cyBiYXNlZCBvbiBzaGFyZWRf YnVmZmVycw0KDQptYXhfd2FsX3NpemUgPSA0R0INCm1pbl93YWxfc2l6ZSA9IDFHQg0KY2hlY2tw b2ludF9jb21wbGV0aW9uX3RhcmdldCA9IDAuOQkjIGNoZWNrcG9pbnQgdGFyZ2V0IGR1cmF0aW9u LCAwLjAgLSAxLjANCg0KYXJjaGl2ZV9tb2RlID0gb24JCSMgZW5hYmxlcyBhcmNoaXZpbmc7IG9m Ziwgb24sIG9yIGFsd2F5cw0KYXJjaGl2ZV9jb21tYW5kID0gJy91c3IvbG9jYWwvYmluL3dhbC1n IHdhbC1wdXNoIFwiJXBcIiA+PgovdmFyL2xvZy9wb3N0Z3Jlc3FsL2FyY2hpdmVfY29tbWFuZC5s b2cgMj4mMScJCSMgY29tbWFuZCB0byB1c2UgdG8gYXJjaGl2ZSBhCmxvZ2ZpbGUgc2VnbWVudA0K YXJjaGl2ZV90aW1lb3V0ID0gNjAJCSMgZm9yY2UgYSBsb2dmaWxlIHNlZ21lbnQgc3dpdGNoIGFm dGVyIHRoaXMNCg0KcmVzdG9yZV9jb21tYW5kID0gJy91c3IvbG9jYWwvYmluL3dhbC1nIHdhbC1m ZXRjaCBcIiVmXCIgXCIlcFwiID4+Ci92YXIvbG9nL3Bvc3RncmVzcWwvcmVzdG9yZV9jb21tYW5k LmxvZyAyPiYxJwkJIyBjb21tYW5kIHRvIHVzZSB0byByZXN0b3JlCmFuIGFyY2hpdmVkIA0KDQpt YXhfd2FsX3NlbmRlcnMgPSAxMAkJIyBtYXggbnVtYmVyIG9mIHdhbHNlbmRlciBwcm9jZXNzZXMN CgkJCQkjIChjaGFuZ2UgcmVxdWlyZXMgcmVzdGFydCkNCndhbF9rZWVwX3NpemUgPSAxMDAwMAkJ IyBpbiBtZWdhYnl0ZXM7IDAgZGlzYWJsZXMNCmhvdF9zdGFuZGJ5ID0gb24JCQkjICJvZmYiIGRp c2FsbG93cyBxdWVyaWVzIGR1cmluZyByZWNvdmVyeQ0KDQptYXhfc3RhbmRieV9zdHJlYW1pbmdf ZGVsYXkgPSAxMHMJIyBtYXggZGVsYXkgYmVmb3JlIGNhbmNlbGluZyBxdWVyaWVzDQoJCQkJCSMg d2hlbiByZWFkaW5nIHN0cmVhbWluZyBXQUw7DQoNCmhvdF9zdGFuZGJ5X2ZlZWRiYWNrID0gb24J CSMgc2VuZCBpbmZvIGZyb20gc3RhbmRieSB0byBwcmV2ZW50DQoJCQkJCSMgcXVlcnkgY29uZmxp Y3RzDQoNCnJhbmRvbV9wYWdlX2Nvc3QgPSA0CQkJIyBzYW1lIHNjYWxlIGFzIGFib3ZlDQoNCmVm ZmVjdGl2ZV9jYWNoZV9zaXplID0gOTZHQg0KDQpkZWZhdWx0X3N0YXRpc3RpY3NfdGFyZ2V0ID0g MTAwCQkjIHJhbmdlIDEtMTAwMDANCg0KbG9nZ2luZ19jb2xsZWN0b3IgPSBvbgkJCSMgRW5hYmxl IGNhcHR1cmluZyBvZiBzdGRlcnIgYW5kIGNzdmxvZw0KDQoNCmxvZ19kaXJlY3RvcnkgPSAnL3Zh ci9sb2cvcG9zdGdyZXNxbCcJIyBkaXJlY3Rvcnkgd2hlcmUgbG9nIGZpbGVzIGFyZQp3cml0dGVu LA0KbG9nX2ZpbGVuYW1lID0gJ3Bvc3RncmVzcWwtMTYtbWFpbi5sb2cnCSMgbG9nIGZpbGUgbmFt ZSBwYXR0ZXJuLA0KbG9nX2ZpbGVfbW9kZSA9IDA2NDQJCQkjIGNyZWF0aW9uIG1vZGUgZm9yIGxv ZyBmaWxlcywNCmxvZ190cnVuY2F0ZV9vbl9yb3RhdGlvbiA9IG9uCQkjIElmIG9uLCBhbiBleGlz dGluZyBsb2cgZmlsZSB3aXRoIHRoZQ0KbG9nX3JvdGF0aW9uX2FnZSA9IDFkCQkJIyBBdXRvbWF0 aWMgcm90YXRpb24gb2YgbG9nZmlsZXMgd2lsbA0KbG9nX3JvdGF0aW9uX3NpemUgPSAxMDI0TUIJ CSMgQXV0b21hdGljIHJvdGF0aW9uIG9mIGxvZ2ZpbGVzIHdpbGwNCmxvZ19taW5fZHVyYXRpb25f c3RhdGVtZW50ID0gMAkJIyAtMSBpcyBkaXNhYmxlZCwgMCBsb2dzIGFsbCBzdGF0ZW1lbnRzDQoN CmxvZ19jb25uZWN0aW9ucyA9IG9uDQpsb2dfZGlzY29ubmVjdGlvbnMgPSBvbg0KDQpsb2dfbGlu ZV9wcmVmaXg9ICclbSBbJXBdICVkICVhICV1ICVoICVjICcJCSMgc3BlY2lhbCB2YWx1ZXM6DQoN CmNsdXN0ZXJfbmFtZSA9ICcxNi9tYWluJwkJCSMgYWRkZWQgdG8gcHJvY2VzcyB0aXRsZXMgaWYg bm9uZW1wdHkNCg0KdHJhY2tfaW9fdGltaW5nID0gb24NCg0KDQpzdGF0ZW1lbnRfdGltZW91dCA9 IDEwMDAwCQkJIyBpbiBtaWxsaXNlY29uZHMsIDAgaXMgZGlzYWJsZWQNCg0KZGF0ZXN0eWxlID0g J2lzbywgbWR5Jw0KDQpsY19tZXNzYWdlcyA9ICdlbl9VUy5VVEYtOCcJCQkjIGxvY2FsZSBmb3Ig c3lzdGVtIGVycm9yIG1lc3NhZ2UNCmxjX21vbmV0YXJ5ID0gJ2VuX1VTLlVURi04JwkJCSMgbG9j YWxlIGZvciBtb25ldGFyeSBmb3JtYXR0aW5nDQpsY19udW1lcmljID0gJ2VuX1VTLlVURi04JwkJ CSMgbG9jYWxlIGZvciBudW1iZXIgZm9ybWF0dGluZw0KbGNfdGltZSA9ICdlbl9VUy5VVEYtOCcJ CQkJIyBsb2NhbGUgZm9yIHRpbWUgZm9ybWF0dGluZw0KDQpkZWZhdWx0X3RleHRfc2VhcmNoX2Nv bmZpZyA9ICdwZ19jYXRhbG9nLmVuZ2xpc2gnDQoNCnNoYXJlZF9wcmVsb2FkX2xpYnJhcmllcyA9 CidwZ19zdGF0X3N0YXRlbWVudHMscGFzc3dvcmRjaGVjayxhdXRvX2V4cGxhaW4sYXV0aF9kZWxh eSxwZ2F1ZGl0Jw0KcGdfc3RhdF9zdGF0ZW1lbnRzLm1heCA9IDUwMA0KcGdfc3RhdF9zdGF0ZW1l bnRzLnRyYWNrID0gdG9wDQpwZ19zdGF0X3N0YXRlbWVudHMudHJhY2tfdXRpbGl0eSA9IHRydWUN CnBnX3N0YXRfc3RhdGVtZW50cy5zYXZlID0gZmFsc2UNCg0KDQppbmNsdWRlX2RpciA9ICdjb25m LmQnCQkJIyBpbmNsdWRlIGZpbGVzIGVuZGluZyBpbiAnLmNvbmYnIGZyb20NCmF1dGhfZGVsYXku bWlsbGlzZWNvbmRzID0gMTAwMA0KDQpPdXIgdHlwaWNhbCBRUFMgbWV0cmljcyBhcmUgZnJvbSA3 MDAgdG8gMjUwMCBxdWVyaWVzIHBlciBzZWNvbmQNCkxvZyBzaXplIGlzIGFyb3VuZCAyNzAgTWIg cGVyIG1pbnV0ZSAoNjYwMCBsaW5lcyBwZXIgbWludXRlKQ0KDQpUaGUgbHNvZiB1dGlsaXR5IGRp ZCBub3QgaGVscCBpbiBpbnZlc3RpZ2F0aW5nIHRoaXMgcHJvYmxlbSwgYXMgZGlkCnJlc3RhcnRp bmcgdGhlIHNlcnZlcg0KU2V0dGluZyBsb2dfbWluX2R1cmF0aW9uX3N0YXRlbWVudCA9IC0xIHNo b3dzIGEgc2lnbmlmaWNhbnQgZGVjcmVhc2UgaW4gdGhlCmxvYWQgb24gdGhlIGRhdGEgZGlzaw0K U28gSSBjYW4ndCBhc3N1bWUgd2h5IGRhdGEgZGlzayAoL2Rldi92ZGIxIC9kYXRhKSB1dGlsaXpl ZCB1cCB0byA2MC04MCUKd2hpbGUgc3RhdGVtZW50cyBhcmUgbG9nZ2VkIHRvIHNlcGFyYXRlIGJs b2NrIGRldmljZSAoL2Rldi92ZGMxCi92YXIvbG9nL3Bvc3RncmVzcWwpIGFuZCBuZWVkIHNvbWUg aGVscCB0byBnZXQgb2ZmIHRoZSBncm91bmQKCg== --===============6510813755504783712==--