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 1t5PlA-005w3U-Hn for pgsql-bugs@arkaria.postgresql.org; Mon, 28 Oct 2024 13:26:16 +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 1t5Pl8-006isO-RC for pgsql-bugs@arkaria.postgresql.org; Mon, 28 Oct 2024 13:26:15 +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 1t5L9d-004fnD-Q1 for pgsql-bugs@lists.postgresql.org; Mon, 28 Oct 2024 08:31:14 +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 1t5L9W-003Nl6-OO for pgsql-bugs@lists.postgresql.org; Mon, 28 Oct 2024 08:31:13 +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=rUX5FtXMh2jQE1+tjrdWADA3RwLVqn3f5/8NNGcOZbc=; b=m7ht1xLFDCZVxk2Pin1e0lETmS aqmo47Z4fsqkAENa9m6lVTN7S0S6QOGMtffj9rZxAx9HtDStnj4ZcY0eqTpnLTmK6GlyrBtQjSEJE mTxsqdW7Lki0R1V+SLIGW9QnzVsCkq7cixWilk/I/cgzrMjsJwIgmA+61lyOojYP74OSIKbguktiw nkpaYYfN75eC89OrNp9YYWEhYsSJxBGbMQhtbWPM7JwoIz4TxdsgRKrEZcpuZEIpynfdvR9zWgj8Z LrzN9xdBRruvl0gfpHFCGEYX36aWj/4xXvyWkRpvtg9ju7OW/vJzTmkpBkEd7WUyhsKK+i2YCMbVI fc2IKdVg==; 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 1t5L9U-00A1SX-8y for pgsql-bugs@lists.postgresql.org; Mon, 28 Oct 2024 08:31: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 1t5L9S-0011aE-I4 for pgsql-bugs@lists.postgresql.org; Mon, 28 Oct 2024 08:31:03 +0000 Content-Type: multipart/mixed; boundary="===============0057663822392488440==" MIME-Version: 1.0 Subject: BUG #18675: Postgres is not realasing memory causing OOM To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: eccenux@gmail.com Reply-To: eccenux@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 28 Oct 2024 08:30:05 +0000 Message-ID: <18675-39a45505fb472bf0@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 --===============0057663822392488440== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODY3NQpMb2dnZWQgYnk6ICAgICAgICAgIE1hY2llaiBKYXJvcwpFbWFp bCBhZGRyZXNzOiAgICAgIGVjY2VudXhAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTYu NApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNApEZXNjcmlwdGlvbjogICAgICAgIAoK SGkuIFdlIGhhdmUgYSBEQiBzZXJ2ZXIgcnVubmluZyBvbiBhIFZNIGhvc3RlZCBvbiBQcm94bW94 IChaRlMpLiBXZSByZWNlbnRseQp1cGdyYWRlZCBmcm9tIFBHMTAgdG8gUEcxNiBhbmQgbm90aWNl ZCBhbiBpbmNyZWFzZSBpbiBsb2FkIGFuZCwgbW9zdAppbXBvcnRhbnRseSwgKip1bmNvbnRyb2xs ZWQqKiBSQU0gdXNhZ2UgZ3Jvd3RoLiBJbiBteSBjYWxjdWxhdGlvbnMgUkFNIHVzYWdlCnNob3Vs ZCBzdGF5IHVuZGVyIDIwR0IuIEluIHByYWN0aWNlLCB3ZSBmb3VuZCB0aGF0IGV2ZW4gNTBHQiB3 YXNu4oCZdCBlbm91Z2gKZm9yIFBvc3RncmVTUUwsIGFzIE9PTSBraWxsZXIga2lsbGVkIHRoZSBz ZXJ2aWNlLiBXaGF04oCZcyBzdHJhbmdlIGlzIHRoYXQKb25jZSBPT00ga2lsbHMgUG9zdGdyZVNR TCwgdGhlIG1lbW9yeSBkcm9wcyB0byB6ZXJvLCBpbmRpY2F0aW5nIHRoYXQgbm90aGluZwplbHNl IHdhcyB1c2luZyB0aGF0IG1lbW9yeS4gQWZ0ZXIgdGhlIE9PTSwgUG9zdGdyZVNRTCBydW5zIGZp bmUgYWdhaW4sIGJ1dApyZXF1aXJlcyBpbnRlcnZlbnRpb24uIFNvIGFzIGEgd29ya2Fyb3VuZCwg d2XigJlyZSBtYW51YWxseSByZXN0YXJ0aW5nIGl0IGZyb20KdGltZSB0byB0aW1lLg0KDQpUaGlz IGlzIGEgYnVnLCByaWdodD8gSSBtZWFuLCBzdXJlbHkgUG9zdGdyZVNRTCBzaG91bGRuJ3QgZXhj ZWVkIDIwR0IsIG1heWJlCjMwR0IgaWYgSSBtaXNzZWQgc29tZXRoaW5nLiBJJ3ZlIHNlYXJjaGVk IHRoZSB3ZWIgYW5kIGZvdW5kIHBvc3RzIGFza2luZyBob3cKdG8gc2V0IGFuIGFic29sdXRlIG1l bW9yeSBsaW1pdCBmb3IgUG9zdGdyZVNRTCwgb25seSB0byBsZWFybiB0aGF0IG5vIHN1Y2gKc2V0 dGluZyBleGlzdHMuIFBlcmhhcHMgdGhlcmUgc2hvdWxkIGJlIGFuIGFic29sdXRlIGxpbWl0LCBv ciBtYXliZQpQb3N0Z3JlU1FMIHNob3VsZCBpbmNsdWRlIGdhcmJhZ2UgY29sbGVjdGlvbj8NCg0K UkFNIGZvciBQRyBjYWxjdWxhdGlvbiAoYXV0b3ZhYyBpcyBkaXNhYmxlZCwgY3JvbiBydW5zIGF0 IG5pZ2h0IGluc3RlYWQpOg0KYGBgDQpzaGFyZWRfYnVmZmVycyA9IDEyNTQ0DQp0ZW1wX2J1ZmZl cnMgPSA4DQp3b3JrX21lbSA9IDY0MjIvMTAyNA0KbWF4X2Nvbm5lY3Rpb25zID0gNTAwDQpSQU1m b3JQRyA9IHNoYXJlZF9idWZmZXJzICsgKHRlbXBfYnVmZmVycyArIHdvcmtfbWVtKSAqIG1heF9j b25uZWN0aW9uczsNCmNvbnNvbGUubG9nKHtSQU1mb3JQR30pOyAtPiAvLyAxOTY3OS43NA0KYGBg DQoNCk9uZSBvZiBTUUwgY2F1c2luZyBsYXJnZSB0YWJsZXMgdG8gYmUgc2Nhbm5lZDoNCmBgYA0K U0VMRUNUDQoJdGhpc18uaWQgYXMgeTBfLA0KCXRoaXNfLnBmeCBhcyB5MV8sDQoJdGhpc18uYmFz ZSBhcyB5Ml8sDQoJdGhpc18udHlwZSBhcyB5M18sDQoJbG93ZXIodGhpc18ucGZ4KSBhcyBwZnhM b3dlckNvbCwNCglsb3dlcih0aGlzXy5iYXNlKSBhcyBiYXNlTG93ZXJDb2wNCmZyb20NCgkibTYx ODciLkF1dGhvckVudHJ5IHRoaXNfDQp3aGVyZQ0KCXRoaXNfLmJpYmxpb2dyYXBoaWNEYXRhYmFz ZUlkID0gNTY2NzU3DQoJYW5kICgNCgkJZXhpc3RzICgNCgkJCXNlbGVjdA0KCQkJCWRhZWVfLkFV VEhPUkVOVFJZX0lEIGFzIHkwXw0KCQkJZnJvbQ0KCQkJCSJtNjE4NyIuRE9DVU1FTlRfQVVUSE9S IGRhZWVfDQoJCQkJaW5uZXIgam9pbiAibTYxODciLkRvY3VtZW50IGRvYzFfIG9uIGRhZWVfLkRP Q1VNRU5UX0lEID0gZG9jMV8uaWQNCgkJCXdoZXJlDQoJCQkJZGFlZV8uQVVUSE9SRU5UUllfSUQg PSB0aGlzXy5pZA0KCQkJCWFuZCBub3QgZG9jMV8uaGlkZGVuID0gJzInDQoJCSkNCgkJb3IgZXhp c3RzICgNCgkJCXNlbGVjdA0KCQkJCWRhZWVfLkFVVEhPUkVOVFJZX0lEIGFzIHkwXw0KCQkJZnJv bQ0KCQkJCSJtNjE4NyIuRE9DVU1FTlRfQVVUSE9SIGRhZWVfDQoJCQkJaW5uZXIgam9pbiAibTYx ODciLkRvY3VtZW50IGRvYzFfIG9uIGRhZWVfLkRPQ1VNRU5UX0lEID0gZG9jMV8uaWQNCgkJCXdo ZXJlDQoJCQkJZGFlZV8uQVVUSE9SRU5UUllfSUQgPSB0aGlzXy5OT1JNQUxGT1JNX0lEDQoJCQkJ YW5kIG5vdCBkb2MxXy5oaWRkZW4gPSAnMicNCgkJKQ0KCQlvciBleGlzdHMgKA0KCQkJc2VsZWN0 DQoJCQkJZGFlZV8uQVVUSE9SRU5UUllfSUQgYXMgeTBfDQoJCQlmcm9tDQoJCQkJIm02MTg3Ii5E T0NVTUVOVF9BVVRIT1IgZGFlZV8NCgkJCQlpbm5lciBqb2luICJtNjE4NyIuQXV0aG9yRW50cnkg YWUxXyBvbiBkYWVlXy5BVVRIT1JFTlRSWV9JRCA9IGFlMV8uaWQNCgkJCQlpbm5lciBqb2luICJt NjE4NyIuRG9jdW1lbnQgZG9jMl8gb24gZGFlZV8uRE9DVU1FTlRfSUQgPSBkb2MyXy5pZA0KCQkJ d2hlcmUNCgkJCQlhZTFfLk5PUk1BTEZPUk1fSUQgPSB0aGlzXy5pZA0KCQkJCWFuZCBub3QgZG9j Ml8uaGlkZGVuID0gJzInDQoJCSkNCgkJb3IgZXhpc3RzICgNCgkJCXNlbGVjdA0KCQkJCWRhZWVf LkFVVEhPUkVOVFJZX0lEIGFzIHkwXw0KCQkJZnJvbQ0KCQkJCSJtNjE4NyIuRE9DVU1FTlRfQVVU SE9SIGRhZWVfDQoJCQkJaW5uZXIgam9pbiAibTYxODciLkF1dGhvckVudHJ5IGFlMV8gb24gZGFl ZV8uQVVUSE9SRU5UUllfSUQgPSBhZTFfLmlkDQoJCQkJaW5uZXIgam9pbiAibTYxODciLkRvY3Vt ZW50IGRvYzJfIG9uIGRhZWVfLkRPQ1VNRU5UX0lEID0gZG9jMl8uaWQNCgkJCXdoZXJlDQoJCQkJ YWUxXy5OT1JNQUxGT1JNX0lEID0gdGhpc18uTk9STUFMRk9STV9JRA0KCQkJCWFuZCBub3QgZG9j Ml8uaGlkZGVuID0gJzInDQoJCSkNCgkpDQpvcmRlciBieQ0KCWJhc2VMb3dlckNvbCBhc2MsDQoJ cGZ4TG93ZXJDb2wgYXNjDQpsaW1pdCAyNQ0KYGBgCgo= --===============0057663822392488440==--