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 1qM2vv-001HGx-3l for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Jul 2023 08:53:18 +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 1qM2vt-002hJP-JL for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Jul 2023 08:53:17 +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 1qM2ss-002dw9-DS for pgsql-bugs@lists.postgresql.org; Wed, 19 Jul 2023 08:50: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 1qM2so-000Odr-Kg for pgsql-bugs@lists.postgresql.org; Wed, 19 Jul 2023 08:50: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=JnWCUHDHt/dHc1bW3nQsGzLNke5mXE4Q/qLu7e1b0V4=; b=SU2LUP37Oua5PbCwt/7ZcK1mxC Qjg/UllIlEVvu7zvpZzwIlzU+PWZbOs1j6CdHDPkyYVCU8qGYoYYbqS7nnf9hPn2lBECHCi2t8ecf vDGT2YBja8nrYL/mhU7/2HKljJnY+2rrOcQvOQ4qvlf43lS7sOoMHroXi8a/z9muuAFwrHhyh56hs SxmlSQUs4CMz5z2yDdVQmtmJ+14zGRANMqtPNJfbelIrEyLORc6K8Aymk96M/nSp0TAPnxuuT6/cC mMxicFpyest8WlPHIw9LKB/3KMCGAq18imu0j7ZaBIUPRe8nGCDwmmTqFN9mHni7L6K82bMCMk3dw Y52RZ7jQ==; 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 1qM2sm-0002hD-6P for pgsql-bugs@lists.postgresql.org; Wed, 19 Jul 2023 08:50:05 +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 1qM2sj-000roy-Lx for pgsql-bugs@lists.postgresql.org; Wed, 19 Jul 2023 08:50:02 +0000 Content-Type: multipart/mixed; boundary="===============2993268878241754681==" MIME-Version: 1.0 Subject: BUG #18030: Large memory consumption caused by in-clause subqueries To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zuming.jiang@inf.ethz.ch Reply-To: zuming.jiang@inf.ethz.ch, pgsql-bugs@lists.postgresql.org Date: Wed, 19 Jul 2023 08:49:38 +0000 Message-ID: <18030-2a563b7ccc7d6152@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 --===============2993268878241754681== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODAzMApMb2dnZWQgYnk6ICAgICAgICAgIFp1bWluZyBKaWFuZwpFbWFp bCBhZGRyZXNzOiAgICAgIHp1bWluZy5qaWFuZ0BpbmYuZXRoei5jaApQb3N0Z3JlU1FMIHZlcnNp b246IDE2YmV0YTIKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVzY3JpcHRpb246 ICAgICAgICAKCk15IGZ1enplciBmaW5kcyBhIHBvdGVudGlhbCBidWcgaW4gUG9zdGdyZXMsIHdo aWNoIGNvbnN1bWVzIGxvdHMgb2YgbWVtb3J5CmFuZCBmaW5hbGx5IGtpbGxzIHRoZSBQb3N0Z3Jl cyBzZXJ2ZXIgb24gbXkgbWFjaGluZS4NCg0KLS0tIFRlc3QgY2FzZSAtLS0NCmNyZWF0ZSB0YWJs ZSB0MCAodmtleSBpbnQ0LCBjMCBpbnQ0LCBjNSB0ZXh0KTsNCmNyZWF0ZSB0YWJsZSB0NCAoYzI4 IHRleHQpOw0KDQppbnNlcnQgaW50byB0MCB2YWx1ZXMgKDE2LCAtMzIsICdoQ1YnKTsNCmluc2Vy dCBpbnRvIHQwIHZhbHVlcyAoMTgsIDU5LCAnIzt5PSsnKTsNCmluc2VydCBpbnRvIHQwIHZhbHVl cyAoMzMsIDE2LCAneHlPRzsnKTsNCmluc2VydCBpbnRvIHQwIHZhbHVlcyAoNDAsIC0zOCwgJ0l8 ZicpOw0KaW5zZXJ0IGludG8gdDAgdmFsdWVzICg0NCwgLTU4LCAnRicpOw0KaW5zZXJ0IGludG8g dDAgdmFsdWVzICg0NywgODgsICdJJyk7DQppbnNlcnQgaW50byB0MCB2YWx1ZXMgKDUyLCAtMCwg J0JHcksnKTsNCmluc2VydCBpbnRvIHQwIHZhbHVlcyAoNTMsIC03LCAnIFQqaycpOw0KDQppbnNl cnQgaW50byB0NCB2YWx1ZXMgKCdFJyk7DQppbnNlcnQgaW50byB0NCB2YWx1ZXMgKCdsJl4nKTsN Cmluc2VydCBpbnRvIHQ0IHZhbHVlcyAoJycpOw0KaW5zZXJ0IGludG8gdDQgdmFsdWVzICgnWkB+ Jyk7DQppbnNlcnQgaW50byB0NCB2YWx1ZXMgKG51bGw6OnRleHQpOw0KaW5zZXJ0IGludG8gdDQg dmFsdWVzICgnbmdMQCcpOw0KaW5zZXJ0IGludG8gdDQgdmFsdWVzIChudWxsOjp0ZXh0KTsNCmlu c2VydCBpbnRvIHQ0IHZhbHVlcyAoJ00rJyk7DQoNCnNlbGVjdCAqIGZyb20gdDANCndoZXJlDQps cGFkKHQwLmM1LCBpbnQ0bWkodDAudmtleSwgdDAuYzAgPDwgdDAuYzApKSBpbiAoDQogICAgICBz ZWxlY3QNCiAgICAgICAgcmVmXzAuYzI4IGFzIGNfMA0KICAgICAgZnJvbQ0KICAgICAgICB0NCBh cyByZWZfMA0KICAgICAgd2hlcmUgdDAudmtleSA+PSAwKQ0KLS0tDQoNCi0tLSBFeHBlY3RlZCBi ZWhhdmlvciAtLS0NClRoZSB0ZXN0IGNhc2Ugc2hvdWxkIGJlIGV4ZWN1dGVkIHN1Y2Nlc3NmdWxs eS4NCg0KLS0tIEFjdHVhbCBiZWhhdmlvciAtLS0NClBvc3RncmVzIHNlcnZlciBjb25zdW1lcyBs b3RzIG9mIG1lbW9yaWVzIGFuZCBmaW5hbGx5IGdldHMga2lsbGVkDQoNCi0tLSBQb3N0Z3JlcyB2 ZXJzaW9uIC0tLQ0KR2l0aHViIGNvbW1pdDogOGZhYjRiMzQ4MDEzMzFmMWM1OTM1MmNiMGEyNDhi ZTQzNmI2MGFlZg0KVmVyc2lvbjogUG9zdGdyZVNRTCAxN2RldmVsIG9uIHg4Nl82NC1wYy1saW51 eC1nbnUsIGNvbXBpbGVkIGJ5IGNsYW5nCnZlcnNpb24gMTAuMC4wLTR1YnVudHUxICwgNjQtYml0 DQoNCi0tLSBQbGF0Zm9ybSBpbmZvcm1hdGlvbiAtLS0NClBsYXRmb3JtOiBVYnVudHUgMjAuMDQN Cktlcm5lbDogTGludXggNS40LjAtMTQ3LWdlbmVyaWMNCg0KLS0tIE5vdGUgLS0tDQpBZnRlciBJ IHJlcGxhY2UgIndoZXJlIHQwLnZrZXkgPj0gMCIgd2l0aCAid2hlcmUgdHJ1ZSIgKHdoaWNoIGRv ZXMgbm90CmNoYW5nZSBzZW1hbnRpY3MgYmVjYXVzZSB0MC52a2V5IGlzIGFsd2F5cyBsYXJnZXIg dGhhbiAwKSwgdGhlIFNFTEVDVCBxdWVyeQppcyBtdWNoIGZhc3RlciBhbmQgY29uc3VtZXMgbXVj aCBsZXNzIG1lbW9yaWVzLgoK --===============2993268878241754681==--