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 1qwLPX-00BDVR-7d for pgsql-bugs@arkaria.postgresql.org; Fri, 27 Oct 2023 11:53:55 +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 1qwLPV-00Ez0O-Rk for pgsql-bugs@arkaria.postgresql.org; Fri, 27 Oct 2023 11:53:53 +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 1qwKcP-00Ek0i-M6 for pgsql-bugs@lists.postgresql.org; Fri, 27 Oct 2023 11:03:10 +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 1qwKcM-0036EL-9R for pgsql-bugs@lists.postgresql.org; Fri, 27 Oct 2023 11:03:09 +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=kbK57MbWXlsJfIuZ+OJTfVa73UC0GBUibLOIsREguC4=; b=oZ7xxj2JgXSTQd5M3GfNYSw81n 9niIbAUpUJ/gMFL0jGnMNMMsiaD0ANP6EjjKK8vjDOSgvAkIi1pyn7FJRwJDRlipbEVA5nUvnJhTs Ft+YXY2W1Eq9wD6IVXrQLsoHqv69nfR5sPFpZS5I2C/OFfProEjyhWWPne+Gqo1dAdeKNHHr2Ptr7 XFU6L8wGPZy4uEx+DQUAp317e8dIhKBfIQPdsvUehyN/CXno8QuSSN+ptyEFnw8T6TvMWCHJh6aVa FI5vf2EZj/CG6/l8LwOsHid5wR2VEfi7YhcINFrPS7N6ZkR3YlSRgI/C5kTr6sOxAmCGUMm+KKtcr 1dFT0FKQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qwKcK-0005bY-Ff for pgsql-bugs@lists.postgresql.org; Fri, 27 Oct 2023 11:03: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 1qwKcH-009mmm-Pc for pgsql-bugs@lists.postgresql.org; Fri, 27 Oct 2023 11:03:02 +0000 Content-Type: multipart/mixed; boundary="===============7660178090218652772==" MIME-Version: 1.0 Subject: BUG #18172: High memory usage in tSRF function context To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sk@zsrv.org Reply-To: sk@zsrv.org, pgsql-bugs@lists.postgresql.org Date: Fri, 27 Oct 2023 11:02:14 +0000 Message-ID: <18172-9b8c5fc1d676ded3@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 --===============7660178090218652772== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE3MgpMb2dnZWQgYnk6ICAgICAgICAgIFNlcmdlaSBLb3JuaWxvdgpF bWFpbCBhZGRyZXNzOiAgICAgIHNrQHpzcnYub3JnClBvc3RncmVTUUwgdmVyc2lvbjogVW5zdXBw b3J0ZWQvVW5rbm93bgpPcGVyYXRpbmcgc3lzdGVtOiAgIHZhcmlvdXMgTGludXgKRGVzY3JpcHRp b246ICAgICAgICAKCkhlbGxvDQoNCldoaWxlIHJlc2VhcmNoaW5nIHNldmVyYWwgY2FzZXMgb2Yg T09NLCBJIGRpc2NvdmVyZWQgYW4gYXR5cGljYWxseSBoaWdoCm1lbW9yeSBjb25zdW1wdGlvbiBp biB0aGlzIGNhc2U6DQoNCi8qDQogKiB0ZXN0IGRhdGEgbG9va3MgbGlrZSB7InBheSI6IFt7Imlk IjogMSwgInRlc3QiOiAxfV0sICJuYW1lIjogImZvbzEifQ0KICogYWJvdXQgMSwzR2lCIHRvdGFs DQogKi8NCmNyZWF0ZSB0YWJsZSB0ZXN0IChpZCBzZXJpYWwsIGRhdGEganNvbmIpOw0KaW5zZXJ0 IGludG8gdGVzdCAoZGF0YSkgc2VsZWN0IGpzb25iX2J1aWxkX29iamVjdCgnbmFtZScsICdmb28n fHxpLCAncGF5JywKanNvbmJfYnVpbGRfYXJyYXkoanNvbmJfYnVpbGRfb2JqZWN0KCdpZCcsIGks ICd0ZXN0JywgaSAlIDEwKSkpIGZyb20KZ2VuZXJhdGVfc2VyaWVzKDEsMWU3LDEpIGFzIGk7DQoN ClVzaW5nIGdkYiBJIGNhbGxlZCBNZW1vcnlDb250ZXh0U3RhdHMoVG9wUG9ydGFsQ29udGV4dCkg b24gYnJlYWsgcG9pbnQKc3RhbmRhcmRfRXhlY3V0b3JFbmQNCg0Kc3RhdGVtZW50OiBzZWxlY3Qg ZGlzdGluY3QgKGpzb25iX2FycmF5X2VsZW1lbnRzKGRhdGEtPidwYXkyJyktPj4ndGVzdCcpCmZy b20gdGVzdDsNClRvcFBvcnRhbENvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc2ODAg ZnJlZSAoMCBjaHVua3MpOyA1MTIgdXNlZA0KICBQb3J0YWxDb250ZXh0OiAxMDI0IHRvdGFsIGlu IDEgYmxvY2tzOyA2MTYgZnJlZSAoMCBjaHVua3MpOyA0MDggdXNlZDoKPHVubmFtZWQ+DQogICAg RXhlY3V0b3JTdGF0ZTogMTYzODQgdG90YWwgaW4gMiBibG9ja3M7IDE3NjAgZnJlZSAoNSBjaHVu a3MpOyAxNDYyNAp1c2VkDQogICAgICBIYXNoQWdnIG1ldGEgY29udGV4dDogMjQ1NzYgdG90YWwg aW4gMiBibG9ja3M7IDEzODgwIGZyZWUgKDIgY2h1bmtzKTsKMTA2OTYgdXNlZA0KICAgICAgICBF eHByQ29udGV4dDogODE5MiB0b3RhbCBpbiAxIGJsb2NrczsgNzk1MiBmcmVlICgwIGNodW5rcyk7 IDI0MAp1c2VkDQogICAgICB0U1JGIGZ1bmN0aW9uIGFyZ3VtZW50czogMTQ0Mjg0MDU3NiB0b3Rh bCBpbiAxODIgYmxvY2tzOyAyODMzMDk2IGZyZWUKKDM1NiBjaHVua3MpOyAxNDQwMDA3NDgwIHVz ZWQNCiAgICAgIEV4cHJDb250ZXh0OiA4MTkyIHRvdGFsIGluIDEgYmxvY2tzOyA3OTUyIGZyZWUg KDAgY2h1bmtzKTsgMjQwIHVzZWQNCiAgICAgIEV4cHJDb250ZXh0OiA4MTkyIHRvdGFsIGluIDEg YmxvY2tzOyA3OTUyIGZyZWUgKDAgY2h1bmtzKTsgMjQwIHVzZWQNCiAgICAgIEV4cHJDb250ZXh0 OiA4MTkyIHRvdGFsIGluIDEgYmxvY2tzOyA3OTUyIGZyZWUgKDAgY2h1bmtzKTsgMjQwIHVzZWQN CiAgICAgIEV4cHJDb250ZXh0OiA4MTkyIHRvdGFsIGluIDEgYmxvY2tzOyA3OTUyIGZyZWUgKDAg Y2h1bmtzKTsgMjQwIHVzZWQNCiAgICAgIEV4cHJDb250ZXh0OiA4MTkyIHRvdGFsIGluIDEgYmxv Y2tzOyA3OTUyIGZyZWUgKDAgY2h1bmtzKTsgMjQwIHVzZWQNCiAgICAgIEV4cHJDb250ZXh0OiA4 MTkyIHRvdGFsIGluIDEgYmxvY2tzOyA3OTUyIGZyZWUgKDAgY2h1bmtzKTsgMjQwIHVzZWQNCiAg ICAgIEV4cHJDb250ZXh0OiA4MTkyIHRvdGFsIGluIDEgYmxvY2tzOyA3OTUyIGZyZWUgKDAgY2h1 bmtzKTsgMjQwIHVzZWQNCkdyYW5kIHRvdGFsOiAxNDQyOTU2Mjg4IGJ5dGVzIGluIDE5NiBibG9j a3M7IDI5MjA2NDggZnJlZSAoMzYzIGNodW5rcyk7CjE0NDAwMzU2NDAgdXNlZA0KDQpzdGF0ZW1l bnQ6IHNlbGVjdCBkaXN0aW5jdCAoanNvbmJfYXJyYXlfZWxlbWVudHMoZGF0YS0+J3BheTInKS0+ Pid0ZXN0JykKZnJvbSB0ZXN0IHdoZXJlIGRhdGEgPyAncGF5Mic7DQpUb3BQb3J0YWxDb250ZXh0 OiA4MTkyIHRvdGFsIGluIDEgYmxvY2tzOyA3NjgwIGZyZWUgKDAgY2h1bmtzKTsgNTEyIHVzZWQN CiAgUG9ydGFsQ29udGV4dDogMTAyNCB0b3RhbCBpbiAxIGJsb2NrczsgNjE2IGZyZWUgKDAgY2h1 bmtzKTsgNDA4IHVzZWQ6Cjx1bm5hbWVkPg0KICAgIEV4ZWN1dG9yU3RhdGU6IDMyNzY4IHRvdGFs IGluIDMgYmxvY2tzOyAxNjY4MCBmcmVlICg2IGNodW5rcyk7IDE2MDg4CnVzZWQNCiAgICAgIEhh c2hBZ2cgbWV0YSBjb250ZXh0OiA1NzQwOCB0b3RhbCBpbiAyIGJsb2NrczsgNTc0NCBmcmVlICgw IGNodW5rcyk7CjUxNjY0IHVzZWQNCiAgICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4g MSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAyNDAKdXNlZA0KICAgICAgdFNSRiBmdW5j dGlvbiBhcmd1bWVudHM6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVu a3MpOwoyNDAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7 IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAyNDAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIg dG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAyNDAgdXNlZA0KICAgICAg RXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3Mp OyAyNDAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5 NTIgZnJlZSAoMCBjaHVua3MpOyAyNDAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90 YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAyNDAgdXNlZA0KICAgICAgRXhw ckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAy NDAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIg ZnJlZSAoMCBjaHVua3MpOyAyNDAgdXNlZA0KR3JhbmQgdG90YWw6IDE3MzEyMCBieXRlcyBpbiAx NiBibG9ja3M7IDEwMjI4OCBmcmVlICg2IGNodW5rcyk7IDcwODMyIHVzZWQNCg0Kc3RhdGVtZW50 OiBzZWxlY3QgZGlzdGluY3QgKGpzb25iX2FycmF5X2VsZW1lbnRzKGRhdGEtPidwYXknKS0+Pid0 ZXN0JykgZnJvbQp0ZXN0Ow0KVG9wUG9ydGFsQ29udGV4dDogODE5MiB0b3RhbCBpbiAxIGJsb2Nr czsgNzY4MCBmcmVlICgwIGNodW5rcyk7IDUxMiB1c2VkDQogIFBvcnRhbENvbnRleHQ6IDEwMjQg dG90YWwgaW4gMSBibG9ja3M7IDYxNiBmcmVlICgwIGNodW5rcyk7IDQwOCB1c2VkOgo8dW5uYW1l ZD4NCiAgICBFeGVjdXRvclN0YXRlOiAzMjc2OCB0b3RhbCBpbiAzIGJsb2NrczsgMTc5MTIgZnJl ZSAoMTAgY2h1bmtzKTsgMTQ4NTYKdXNlZA0KICAgICAgSGFzaEFnZyBtZXRhIGNvbnRleHQ6IDE1 ODExMjAgdG90YWwgaW4gMiBibG9ja3M7IDU3NDQgZnJlZSAoMCBjaHVua3MpOwoxNTc1Mzc2IHVz ZWQNCiAgICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJl ZSAoMCBjaHVua3MpOyAyNDAKdXNlZA0KICAgICAgdFNSRiBmdW5jdGlvbiBhcmd1bWVudHM6IDgx OTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3MpOwoyNDAgdXNlZA0KICAg ICAgRXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVu a3MpOyAyNDAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7 IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAyNDAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIg dG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAyNDAgdXNlZA0KICAgICAg RXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3Mp OyAyNDAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc0 NzIgZnJlZSAoMCBjaHVua3MpOyA3MjAgdXNlZA0KICAgICAgRXhwckNvbnRleHQ6IDgxOTIgdG90 YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAyNDAgdXNlZA0KICAgICAgRXhw ckNvbnRleHQ6IDgxOTIgdG90YWwgaW4gMSBibG9ja3M7IDc5NTIgZnJlZSAoMCBjaHVua3MpOyAy NDAgdXNlZA0KR3JhbmQgdG90YWw6IDE2OTY4MzIgYnl0ZXMgaW4gMTYgYmxvY2tzOyAxMDMwNDAg ZnJlZSAoMTAgY2h1bmtzKTsgMTU5Mzc5Mgp1c2VkDQoNClRoZSBmaXJzdCBxdWVyeSBjb25zdW1l cyBtdWNoIG1vcmUgbWVtb3J5OyBub3RlIHRoYXQgaXQgcmVmZXJzIHRvIGEKbm9uLWV4aXN0ZW50 IGpzb24ga2V5LiBRdWVyeWluZyBmb3IgYSBrZXkgdGhhdCBleGlzdHMgaW4gSlNPTiBvciBjaGVj a2luZwpmb3IgdGhlIGV4aXN0ZW5jZSBvZiBhIGtleSBpbiB3aGVyZSBjbGF1c2UgY29ycmVjdHMg bWVtb3J5IGNvbnN1bXB0aW9uLiBCdXQsCnVuZm9ydHVuYXRlbHksIGRhdGEgYW5hbHlzdHMgd3Jp dGUgdGhlIHF1ZXJ5IGV4YWN0bHkgbGlrZSB0aGUgZmlyc3QKc3RhdGVtZW50LCBub3QgbGlrZSB0 aGUgc2Vjb25kIHN0YXRlbWVudC4NCg0KUXVlcmllcywgb2YgY291cnNlLCBhcmUgY29ycmVjdGVk IGxhdGVyLCBidXQgbWF5YmUgaXQgaXMgcG9zc2libGUgdG8gaW1wcm92ZQptZW1vcnkgY29uc3Vt cHRpb24gZm9yIHRoaXMgY2FzZT8NCg0KTWVtb3J5Q29udGV4dFN0YXRzIGFib3ZlIGFyZSBmcm9t IG15IGxvY2FsIDE3ZGV2ZWwKKDgzNTEwNTM0ZDVmM2YxMTZlZmEwMzU2MzliOWI2MmI4YzZjNGRm MzQgY29tbWl0KSwgb2NjdXJzIGZvciBhbGwgc3VwcG9ydGVkCnZlcnNpb25zLg0KDQpyZWdhcmRz LCBTZXJnZWkKCg== --===============7660178090218652772==--