Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcPzW-0001DK-Ti for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Mar 2023 12:12:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcPzV-0007gy-LH for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Mar 2023 12:12:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcN87-0000Pg-Nb for pgsql-bugs@lists.postgresql.org; Wed, 15 Mar 2023 09:09:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pcN85-0003Rn-87 for pgsql-bugs@lists.postgresql.org; Wed, 15 Mar 2023 09:09:06 +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=8ngFtaAtDh8aNkvOvnIEeVJXkekt9Be8Chxf/W9jwQ0=; b=TYj7rjEUwXwH1/Lh1gHvfNQgI8 B3aZGNO85DMsg7mrq0yGorLBP15Sl9gj7YzP5jtvGot0x+xTJC8NbyS6n8CY9Ro+xeF4DM1oELCRQ VgWQkZEH1SbapDsTYfTXvnGEhyC6iqYc337EgSFh1Mv9GmtwqaT80b8G9VZNgAek+jJ5OYrmnGW4p EJVRiSqwjAYLKP0qgamEbQUACOIZC30mxXNcpXOHhVy096R9kukCeSnoWcpAwsIO8Phr8n+RZjiva jmA8oDSfXzpldhKr1B5MVkp/kZ8jiAf3BJ++bhB1wS1tGEplcyg+GUKZYD+N5Chdz/TuiLMuu+Ejc DE4Ztfdg==; 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 1pcN84-0004kc-91 for pgsql-bugs@lists.postgresql.org; Wed, 15 Mar 2023 09:09: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 1pcN81-00CdAS-K2 for pgsql-bugs@lists.postgresql.org; Wed, 15 Mar 2023 09:09:02 +0000 Content-Type: multipart/mixed; boundary="===============1409460022403433335==" MIME-Version: 1.0 Subject: BUG #17844: Memory consumption for memoize node To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: alexey.ermakov@dataegret.com Reply-To: alexey.ermakov@dataegret.com, pgsql-bugs@lists.postgresql.org Date: Wed, 15 Mar 2023 09:08:18 +0000 Message-ID: <17844-d2f6f9e75a622bed@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 --===============1409460022403433335== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg0NApMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhleSBFcm1ha292CkVt YWlsIGFkZHJlc3M6ICAgICAgYWxleGV5LmVybWFrb3ZAZGF0YWVncmV0LmNvbQpQb3N0Z3JlU1FM IHZlcnNpb246IDE0LjcKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRp b246ICAgICAgICAKCkhlbGxvLCByZWNlbnRseSBJIGZvdW5kIGludGVyZXN0aW5nIHF1ZXJ5IHdo aWNoIGNvbnN1bWUgYSBsb3Qgb2YgbWVtb3J5CihtdWNoIG1vcmUgdGhhbiBleHBlY3RlZCB3aXRo IGN1cnJlbnQgd29ya19tZW0gYW5kIGhhc2hfbWVtX211bHRpcGxpZXIKc2V0dGluZ3MpIGFuZCB0 cmlnZ2VycyBPT00ga2lsbGVyLg0KDQpBZnRlciBzaW1wbGlmeWluZyBxdWVyeSBsb29rcyBsaWtl IHRoZXJlIGlzIGEgcHJvYmxlbSBpbiBwYXJ0IHdoZXJlIHdlIGpvaW4KdGFibGUgb24gY29uZGl0 aW9uIGxpa2U6DQppZCA9ICgoKHRlc3RfanNvbi5iaWdfanNvbl9jb2x1bW4pOjpqc29uIC0+PiAn aWQnOjp0ZXh0KSk6OmludGVnZXINCmFuZCB0aGVyZSBpcyBhIG1lbW9pemUgbm9kZSBpbiB0aGUg cGxhbi4gV2l0aG91dCBtZW1vaXplIG5vZGUgcXVlcnkgd29ya3MKZmluZS4NCg0KSSB3YXMgYWJs ZSB0byBjcmVhdGUgcmVwcm9kdWNpYmxlIHRlc3QgY2FzZSAob24gbWFjaGluZSB3aXRoIGRlZmF1 bHQgY29uZmlnCmFuZCBwb3N0Z3Jlc3FsIDE0LjcpOg0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N CmNyZWF0ZSBleHRlbnNpb24gcGdjcnlwdG87DQotLWNyZWF0ZSBmdW5jdGlvbiB0byBnZW5lcmF0 ZSBkdW1teSBkYXRhDQpDUkVBVEUgT1IgUkVQTEFDRSBGVU5DVElPTiBnZW5lcmF0ZV9yYW5kb21f c3RyaW5nKHNpemUgSU5UKSBSRVRVUk5TIFRFWFQgQVMKJCQNCkRFQ0xBUkUNCiAgY2hhcmFjdGVy cyBURVhUIDo9CidBQkNERUZHSElKS0xNTk9QUVJTVFVWV1hZWmFiY2RlZmdoaWprbG1ub3BxcnN0 dXZ3eHl6MDEyMzQ1Njc4OSc7DQogIGJ5dGVzIEJZVEVBIDo9IGdlbl9yYW5kb21fYnl0ZXMoc2l6 ZSk7DQogIGwgSU5UIDo9IGxlbmd0aChjaGFyYWN0ZXJzKTsNCiAgaSBJTlQgOj0gMDsNCiAgb3V0 cHV0IFRFWFQgOj0gJyc7DQpCRUdJTg0KICBXSElMRSBpIDwgc2l6ZSBMT09QDQogICAgb3V0cHV0 IDo9IG91dHB1dCB8fCBzdWJzdHIoY2hhcmFjdGVycywgZ2V0X2J5dGUoYnl0ZXMsIGkpICUgbCAr IDEsIDEpOw0KICAgIGkgOj0gaSArIDE7DQogIEVORCBMT09QOw0KICBSRVRVUk4gb3V0cHV0Ow0K RU5EOw0KJCQgTEFOR1VBR0UgcGxwZ3NxbCBWT0xBVElMRTsNCg0KDQotLWNyZWF0ZSB0YWJsZSB3 aXRoIDIwMGsgcm93cyBhbmQgdGV4dCBjb2x1bW4gd2l0aCBjb250ZW50IGxpa2UKYHsicmFuZG9t X3N0cmluZyI6Ii4uLi4iLCAiaWQiOjF9YA0KY3JlYXRlIHRhYmxlIHRlc3RfanNvbiBhcw0Kc2Vs ZWN0IGlkLCAoJ3sicmFuZG9tX3N0cmluZyI6IicgfHwgZ2VuZXJhdGVfcmFuZG9tX3N0cmluZyg1 MDApIHx8ICciLAoiaWQiOicgfHwgaWQgfHwgJ30nKTo6dGV4dCBhcyBiaWdfanNvbl9jb2x1bW4N CmZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsMjAwMDAwKSBncyhpZCk7DQoNCi0tZHVwbGljYXRlIHJv d3MgYW5kIHVwZGF0ZSBzdGF0aXN0aWNzICh0byB0cmlnZ2VyIG1lbW9pemUgbm9kZSkNCmluc2Vy dCBpbnRvIHRlc3RfanNvbiBzZWxlY3QgKiBmcm9tIHRlc3RfanNvbjsNCmFuYWx5emUgdGVzdF9q c29uOw0KDQotLWFub3RoZXIgdGFibGUgd2l0aCBzaW1pbGFyIHN0cnVjdHVyZSBhbmQgMTAwayBy b3dzDQpjcmVhdGUgdGFibGUgdGVzdF9qc29uMiBhcw0Kc2VsZWN0IGlkLCAoJ3sicmFuZG9tX3N0 cmluZyI6IicgfHwgZ2VuZXJhdGVfcmFuZG9tX3N0cmluZyg1MDApIHx8ICciLAoiaWQiOicgfHwg aWQgfHwgJ30nKTo6anNvbiBhcyBiaWdfanNvbl9jb2x1bW4NCmZyb20gZ2VuZXJhdGVfc2VyaWVz KDEsMTAwMDAwKSBncyhpZCk7DQphbHRlciB0YWJsZSB0ZXN0X2pzb24yIGFkZCBwcmltYXJ5IGtl eShpZCk7DQoNCi0tdGFibGUgc2l6ZXM6IHRlc3RfanNvbiAtIDIyM01CLCB0ZXN0X2pzb24yIC0g NTZNQg0KDQotLWNoYW5nZSBzZXR0aW5ncyB0byB0cmlnZ2VyIHBsYW4gd2l0aCBtZW1vaXplIG5v ZGUNCnNldCB3b3JrX21lbSA9ICcxMjhNQic7DQpzZXQgZW5hYmxlX2hhc2hqb2luID0gb2ZmOw0K c2V0IGVuYWJsZV9tZXJnZWpvaW4gPSBvZmY7DQpzZXQgaml0ID0gb2ZmOw0KDQpleHBsYWluIChh bmFseXplLCBidWZmZXJzKSBzZWxlY3QgdGVzdF9qc29uLmlkLCB0ZXN0X2pzb24yLmlkIGZyb20g dGVzdF9qc29uCmxlZnQgam9pbiB0ZXN0X2pzb24yIG9uIHRlc3RfanNvbjIuaWQgPQooKHRlc3Rf anNvbi5iaWdfanNvbl9jb2x1bW46Ompzb24pLT4+J2lkJyk6OmludDsNCiBOZXN0ZWQgTG9vcCBM ZWZ0IEpvaW4gIChjb3N0PTAuMzIuLjEwODA0Ny4yMiByb3dzPTQwMDAwMCB3aWR0aD04KSAoYWN0 dWFsCnRpbWU9MC4wMzEuLjMxNTUuMjYxIHJvd3M9NDAwMDAwIGxvb3BzPTEpDQogICBCdWZmZXJz OiBzaGFyZWQgaGl0PTQxNTczOSByZWFkPTEyODM0DQogICBJL08gVGltaW5nczogcmVhZD0xOC4y NTQNCiAgIC0+ICBTZXEgU2NhbiBvbiB0ZXN0X2pzb24gIChjb3N0PTAuMDAuLjMyNTcyLjAwIHJv d3M9NDAwMDAwIHdpZHRoPTU0MCkKKGFjdHVhbCB0aW1lPTAuMDA1Li41Ny4yNDggcm93cz00MDAw MDAgbG9vcHM9MSkNCiAgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MTU3MzggcmVhZD0xMjgz NA0KICAgICAgICAgSS9PIFRpbWluZ3M6IHJlYWQ9MTguMjU0DQogICAtPiAgTWVtb2l6ZSAgKGNv c3Q9MC4zMi4uMC4zNCByb3dzPTEgd2lkdGg9NCkgKGFjdHVhbCB0aW1lPTAuMDA4Li4wLjAwOApy b3dzPTAgbG9vcHM9NDAwMDAwKQ0KICAgICAgICAgQ2FjaGUgS2V5OiAoKCh0ZXN0X2pzb24uYmln X2pzb25fY29sdW1uKTo6anNvbiAtPj4KJ2lkJzo6dGV4dCkpOjppbnRlZ2VyDQogICAgICAgICBD YWNoZSBNb2RlOiBsb2dpY2FsDQogICAgICAgICBIaXRzOiAyMDAwMDAgIE1pc3NlczogMjAwMDAw ICBFdmljdGlvbnM6IDAgIE92ZXJmbG93czogMCAgTWVtb3J5ClVzYWdlOiAxNjc5N2tCDQogICAg ICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0PTQwMDAwMQ0KICAgICAgICAgLT4gIEluZGV4IE9ubHkg U2NhbiB1c2luZyB0ZXN0X2pzb24yX3BrZXkgb24gdGVzdF9qc29uMiAKKGNvc3Q9MC4zMC4uMC4z MyByb3dzPTEgd2lkdGg9NCkgKGFjdHVhbCB0aW1lPTAuMDAxLi4wLjAwMSByb3dzPTAKbG9vcHM9 MjAwMDAwKQ0KICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGlkID0gKCgodGVzdF9qc29uLmJp Z19qc29uX2NvbHVtbik6Ompzb24gLT4+CidpZCc6OnRleHQpKTo6aW50ZWdlcikNCiAgICAgICAg ICAgICAgIEhlYXAgRmV0Y2hlczogMA0KICAgICAgICAgICAgICAgQnVmZmVyczogc2hhcmVkIGhp dD00MDAwMDENCiBQbGFubmluZyBUaW1lOiAwLjA2OSBtcw0KIEV4ZWN1dGlvbiBUaW1lOiAzMjI3 LjA3OCBtcw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoNCkR1cmluZyBleGVjdXRpb24gSSBsb29r ZWQgb24gImF2YWlsIE1lbSIgaW4gdG9wIG91dHB1dCBvbiB0ZXN0IG1hY2hpbmUgdG8KY2hlY2sg aG93IG11Y2ggbWVtb3J5IHByb2Nlc3MgY29uc3VtZS4gSXQgbG9va2VkIGRpZmZlcmVudCBlYWNo IHRpbWUsCnVzdWFsbHkgaHVuZHJlZHMgb2YgTUIsIHNvbWV0aW1lIGFyb3VuZCAxLjVHQiAod2hp Y2ggaXMgZXZlbiBiaWdnZXIgdGhhbgp0YWJsZSBzaXplKS4NCkkgd2FzIGFibGUgdG8gdHJpZ2dl ciBPT00ga2lsbGVyIHdpdGggdGhpcyBxdWVyeSBhbmQgYmlnZ2VyIHRlc3RfanNvbiB0YWJsZQp3 aXRoIHNpbWlsYXIgZGF0YS4NCg0KSSdtIHdvbmRlcmluZzoNCjEpIElzIGl0IGEga25vd24gYnVn ID8gRG9lcyBpdCByZWxhdGUgdG8ganNvbiBwYXJzaW5nIHNvbWVob3cgPw0KMikgSXMgaXQgcG9z c2libGUgdG8gc2hvdyBzdWNoIG1lbW9yeSBjb25zdW1wdGlvbiBpbiBleHBsYWluIChhbmFseXpl LApidWZmZXJzKSBvdXRwdXQgZm9yIGVhc2llciB0cm91Ymxlc2hvb3RpbmcgPw0KDQotLQ0KVGhh bmtzLA0KQWxleGV5IEVybWFrb3YKCg== --===============1409460022403433335==--