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 1oBNfj-0000l9-7B for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Jul 2022 21:43:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oBNfi-0001Du-44 for pgsql-bugs@arkaria.postgresql.org; Tue, 12 Jul 2022 21:43:58 +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 1oBIiA-0005Ko-L0 for pgsql-bugs@lists.postgresql.org; Tue, 12 Jul 2022 16:26:10 +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 1oBIi5-0003Jq-Hs for pgsql-bugs@lists.postgresql.org; Tue, 12 Jul 2022 16:26: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=m+TOR8uWvKvesuBMCo4ujN2Q0Oz0IcPFPhY+L+iRBHI=; b=IQSQjuK7KbKHS8XKrWUGCXk9SK 0NNIekoGrTJz/tVyx97QkQ9pARn4EqowPmTTs4uwb5uujGaaKmaKAmevvrLX+m2u8HIn3MLMKYJl1 i2rLCNtoQyVm3BZYHF2ZgB6CsNmXe6h+2AB9GAVotedrpZDvJy/qTB7E6YzftVju9fDwVIV0X87j2 X/0NM3nB6dq26yaVEqOi9+CRz/WFzLfEDnZiWtV1O/bK5BUYveaD58i6Oi1u2bgAC2sGlvfXmFBJt yLtUW96I18gwP7IywpPya0TT8meACt0SskpSMOKn9miUAfG5P+Xy6IFwh/PYxnD2HfyCBaFy5dbGD aLawxLLA==; 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 1oBIi3-0000rP-R5 for pgsql-bugs@lists.postgresql.org; Tue, 12 Jul 2022 16:26: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 1oBIi1-009FUs-ST for pgsql-bugs@lists.postgresql.org; Tue, 12 Jul 2022 16:26:02 +0000 Content-Type: multipart/mixed; boundary="===============6608096882429577768==" MIME-Version: 1.0 Subject: BUG #17548: Aggregate queries on partitioned tables can cause OOM. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: chjischj@163.com Reply-To: chjischj@163.com, pgsql-bugs@lists.postgresql.org Date: Tue, 12 Jul 2022 16:25:58 +0000 Message-ID: <17548-4d206a94ee58f3a5@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 --===============6608096882429577768== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU0OApMb2dnZWQgYnk6ICAgICAgICAgIENoZW4gaHVhanVuCkVtYWls IGFkZHJlc3M6ICAgICAgY2hqaXNjaGpAMTYzLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEyLjEx Ck9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudE9TIExpbnV4IHJlbGVhc2UgNy45LjIwMDkgKENvcmUp CkRlc2NyaXB0aW9uOiAgICAgICAgCgpBZ2dyZWdhdGUgcXVlcmllcyBvbiBwYXJ0aXRpb25lZCB0 YWJsZXMgY2FuIGNhdXNlIG91dCBvZiBtZW1vcnkgZXJyb3IuDQoNCkV4YW1wbGVzIGFyZSBhcyBm b2xsb3dzDQoNCkNSRUFURSBUQUJMRSB0YnBhcnQgKA0KICAgIGlkICAgICAgICAgaW50LA0KICAg IGMxICAgICAgICAgaW50DQopIFBBUlRJVElPTiBCWSBIQVNIIChjMSk7DQpjcmVhdGUgdGFibGUg dGJwYXJ0XzAgcGFydGl0aW9uIG9mIHRicGFydCBmb3IgdmFsdWVzIHdpdGggKE1PRFVMVVMgCjQs cmVtYWluZGVyIDApOw0KY3JlYXRlIHRhYmxlIHRicGFydF8xIHBhcnRpdGlvbiBvZiB0YnBhcnQg Zm9yIHZhbHVlcyB3aXRoIChNT0RVTFVTIAo0LHJlbWFpbmRlciAxKTsNCmNyZWF0ZSB0YWJsZSB0 YnBhcnRfMiBwYXJ0aXRpb24gb2YgdGJwYXJ0IGZvciB2YWx1ZXMgd2l0aCAoTU9EVUxVUyAKNCxy ZW1haW5kZXIgMik7DQpjcmVhdGUgdGFibGUgdGJwYXJ0XzMgcGFydGl0aW9uIG9mIHRicGFydCBm b3IgdmFsdWVzIHdpdGggKE1PRFVMVVMgCjQscmVtYWluZGVyIDMpOw0KaW5zZXJ0IGludG8gdGJw YXJ0IHNlbGVjdCBpZCxpZCBmcm9tIGdlbmVyYXRlX3NlcmllcygxLDUwMDAwMDAwKWlkOw0KDQoN CnBvc3RncmVzPSMgc2V0IG1heF9wYXJhbGxlbF93b3JrZXJzX3Blcl9nYXRoZXIgPTA7DQpTRVQN CnBvc3RncmVzPSMgc2VsZWN0IGlkLGNvdW50KCopIGZyb20gdGJwYXJ0IGdyb3VwIGJ5IGlkOw0K RVJST1I6ICBvdXQgb2YgbWVtb3J5DQpERVRBSUw6ICBGYWlsZWQgb24gcmVxdWVzdCBvZiBzaXpl IDE2MTA2MTI3MzYgaW4gbWVtb3J5IGNvbnRleHQKIkV4ZWN1dG9yU3RhdGUiLg0KDQoNClRoZSBj YWxsIHN0YWNrIG91dHB1dCBieSBnZGIgaXMgYXMgZm9sbG93c++8mg0KDQpCcmVha3BvaW50IDEs IGVycnN0YXJ0IChlbGV2ZWw9MjAsIGZpbGVuYW1lPTB4YmRlM2MzICJtY3h0LmMiLCBsaW5lbm89 OTEwLA0KICAgIGZ1bmNuYW1lPTB4YmRlNGEwIDxfX2Z1bmNfXy42NjE4PiAiTWVtb3J5Q29udGV4 dEFsbG9jRXh0ZW5kZWQiLApkb21haW49MHgwKSBhdCBlbG9nLmM6MjM1DQoyMzUgICAgICAgICAg ICAgYm9vbCAgICAgICAgICAgIG91dHB1dF90b19jbGllbnQgPSBmYWxzZTsNCihnZGIpIGJ0DQoj MCAgZXJyc3RhcnQgKGVsZXZlbD0yMCwgZmlsZW5hbWU9MHhiZGUzYzMgIm1jeHQuYyIsIGxpbmVu bz05MTAsDQogICAgZnVuY25hbWU9MHhiZGU0YTAgPF9fZnVuY19fLjY2MTg+ICJNZW1vcnlDb250 ZXh0QWxsb2NFeHRlbmRlZCIsCmRvbWFpbj0weDApIGF0IGVsb2cuYzoyMzUNCiMxICAweDAwMDAw MDAwMDBhMWI5ZWQgaW4gTWVtb3J5Q29udGV4dEFsbG9jRXh0ZW5kZWQgKGNvbnRleHQ9MHgxOWZi ZjcwLApzaXplPTE2MTA2MTI3MzYsIGZsYWdzPTUpIGF0IG1jeHQuYzo5MDYNCiMyICAweDAwMDAw MDAwMDA2YTViMDYgaW4gdHVwbGVoYXNoX2FsbG9jYXRlICh0eXBlPTB4MWExMGUyOCwKc2l6ZT0x NjEwNjEyNzM2KQ0KICAgIGF0IC4uLy4uLy4uL3NyYy9pbmNsdWRlL2xpYi9zaW1wbGVoYXNoLmg6 MzE5DQojMyAgMHgwMDAwMDAwMDAwNmE1ZDMzIGluIHR1cGxlaGFzaF9ncm93ICh0Yj0weDFhMTBl MjgsIG5ld3NpemU9NjcxMDg4NjQpDQogICAgYXQgLi4vLi4vLi4vc3JjL2luY2x1ZGUvbGliL3Np bXBsZWhhc2guaDo0MDENCiM0ICAweDAwMDAwMDAwMDA2YTVmNzQgaW4gdHVwbGVoYXNoX2luc2Vy dCAodGI9MHgxYTEwZTI4LCBrZXk9MHgwLApmb3VuZD0weDdmZmMwYzRjNzQ1NykNCiAgICBhdCAu Li8uLi8uLi9zcmMvaW5jbHVkZS9saWIvc2ltcGxlaGFzaC5oOjUyNg0KIzUgIDB4MDAwMDAwMDAw MDZhNmU4ZCBpbiBMb29rdXBUdXBsZUhhc2hFbnRyeSAoaGFzaHRhYmxlPTB4MWExMTEyOCwKc2xv dD0weDFhMTEwOTgsIGlzbmV3PTB4N2ZmYzBjNGM3NDk3KQ0KICAgIGF0IGV4ZWNHcm91cGluZy5j OjMyMA0KIzYgIDB4MDAwMDAwMDAwMDZjMjAyZiBpbiBsb29rdXBfaGFzaF9lbnRyeSAoYWdnc3Rh dGU9MHgxOWZjMzMwKSBhdApub2RlQWdnLmM6MTQ4MA0KIzcgIDB4MDAwMDAwMDAwMDZjMjE0ZiBp biBsb29rdXBfaGFzaF9lbnRyaWVzIChhZ2dzdGF0ZT0weDE5ZmMzMzApIGF0Cm5vZGVBZ2cuYzox NTI0DQojOCAgMHgwMDAwMDAwMDAwNmMyOTA1IGluIGFnZ19maWxsX2hhc2hfdGFibGUgKGFnZ3N0 YXRlPTB4MTlmYzMzMCkgYXQKbm9kZUFnZy5jOjE5MzcNCiM5ICAweDAwMDAwMDAwMDA2YzIxZWIg aW4gRXhlY0FnZyAocHN0YXRlPTB4MTlmYzMzMCkgYXQgbm9kZUFnZy5jOjE1NTYNCiMxMCAweDAw MDAwMDAwMDA2YjJiZTAgaW4gRXhlY1Byb2NOb2RlRmlyc3QgKG5vZGU9MHgxOWZjMzMwKSBhdApl eGVjUHJvY25vZGUuYzo0NDUNCiMxMSAweDAwMDAwMDAwMDA2YThiODQgaW4gRXhlY1Byb2NOb2Rl IChub2RlPTB4MTlmYzMzMCkgYXQKLi4vLi4vLi4vc3JjL2luY2x1ZGUvZXhlY3V0b3IvZXhlY3V0 b3IuaDoyNDINCiMxMiAweDAwMDAwMDAwMDA2YWFlY2IgaW4gRXhlY3V0ZVBsYW4gKGVzdGF0ZT0w eDE5ZmMwODAsCnBsYW5zdGF0ZT0weDE5ZmMzMzAsIHVzZV9wYXJhbGxlbF9tb2RlPWZhbHNlLA0K ICAgIG9wZXJhdGlvbj1DTURfU0VMRUNULCBzZW5kVHVwbGVzPXRydWUsIG51bWJlclR1cGxlcz0w LApkaXJlY3Rpb249Rm9yd2FyZFNjYW5EaXJlY3Rpb24sIGRlc3Q9MHgxOWQ5NWE4LA0KICAgIGV4 ZWN1dGVfb25jZT10cnVlKSBhdCBleGVjTWFpbi5jOjE2MzINCiMxMyAweDAwMDAwMDAwMDA2YTkw NjEgaW4gc3RhbmRhcmRfRXhlY3V0b3JSdW4gKHF1ZXJ5RGVzYz0weDE5YmYwMTAsCmRpcmVjdGlv bj1Gb3J3YXJkU2NhbkRpcmVjdGlvbiwgY291bnQ9MCwNCiAgICBleGVjdXRlX29uY2U9dHJ1ZSkg YXQgZXhlY01haW4uYzozNTANCiMxNCAweDAwMDAwMDAwMDA2YThmMDYgaW4gRXhlY3V0b3JSdW4g KHF1ZXJ5RGVzYz0weDE5YmYwMTAsCmRpcmVjdGlvbj1Gb3J3YXJkU2NhbkRpcmVjdGlvbiwgY291 bnQ9MCwNCiAgICBleGVjdXRlX29uY2U9dHJ1ZSkgYXQgZXhlY01haW4uYzoyOTQNCiMxNSAweDAw MDAwMDAwMDA4ODE5ZTMgaW4gUG9ydGFsUnVuU2VsZWN0IChwb3J0YWw9MHgxOTgyYmYwLCBmb3J3 YXJkPXRydWUsCmNvdW50PTAsIGRlc3Q9MHgxOWQ5NWE4KSBhdCBwcXVlcnkuYzo5MzgNCiMxNiAw eDAwMDAwMDAwMDA4ODE2YmQgaW4gUG9ydGFsUnVuIChwb3J0YWw9MHgxOTgyYmYwLApjb3VudD05 MjIzMzcyMDM2ODU0Nzc1ODA3LCBpc1RvcExldmVsPXRydWUsIHJ1bl9vbmNlPXRydWUsDQogICAg ZGVzdD0weDE5ZDk1YTgsIGFsdGRlc3Q9MHgxOWQ5NWE4LCBjb21wbGV0aW9uVGFnPTB4N2ZmYzBj NGM3ODgwICIiKSBhdApwcXVlcnkuYzo3NzkNCiMxNyAweDAwMDAwMDAwMDA4N2JjMDkgaW4gZXhl Y19zaW1wbGVfcXVlcnkgKHF1ZXJ5X3N0cmluZz0weDE5MWNkYTAgInNlbGVjdAppZCxjb3VudCgq KSBmcm9tIHRicGFydCBncm91cCBieSBpZDsiKQ0KICAgIGF0IHBvc3RncmVzLmM6MTIxNQ0KIzE4 IDB4MDAwMDAwMDAwMDg3ZmJiOSBpbiBQb3N0Z3Jlc01haW4gKGFyZ2M9MSwgYXJndj0weDE5NDZk MzAsCmRibmFtZT0weDE5NDZiZjggInBvc3RncmVzIiwNCiAgICB1c2VybmFtZT0weDE5NDZiZDgg InBvc3RncmVzIikgYXQgcG9zdGdyZXMuYzo0MjgxDQojMTkgMHgwMDAwMDAwMDAwN2U2YmM5IGlu IEJhY2tlbmRSdW4gKHBvcnQ9MHgxOTNlYmQwKSBhdCBwb3N0bWFzdGVyLmM6NDUxMA0KIzIwIDB4 MDAwMDAwMDAwMDdlNjNiMCBpbiBCYWNrZW5kU3RhcnR1cCAocG9ydD0weDE5M2ViZDApIGF0CnBv c3RtYXN0ZXIuYzo0MTkzDQojMjEgMHgwMDAwMDAwMDAwN2UyYTg3IGluIFNlcnZlckxvb3AgKCkg YXQgcG9zdG1hc3Rlci5jOjE3MjUNCiMyMiAweDAwMDAwMDAwMDA3ZTIzNjAgaW4gUG9zdG1hc3Rl ck1haW4gKGFyZ2M9MywgYXJndj0weDE5MTdhNDApIGF0CnBvc3RtYXN0ZXIuYzoxMzk4DQojMjMg MHgwMDAwMDAwMDAwNzBmNTRlIGluIG1haW4gKGFyZ2M9MywgYXJndj0weDE5MTdhNDApIGF0IG1h aW4uYzoyMjgNCg0Kbm90ZTogUEcgMTQgZG9lcyBub3QgaGF2ZSB0aGlzIHByb2JsZW0KCg== --===============6608096882429577768==--