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.96) (envelope-from ) id 1vZ9qJ-004TJn-0R for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Dec 2025 15:35:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vZ9qH-009lvn-1m for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Dec 2025 15:35:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vZ9QF-009do4-2L for pgsql-bugs@lists.postgresql.org; Fri, 26 Dec 2025 15:08:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vZ9QE-002j0H-2L for pgsql-bugs@lists.postgresql.org; Fri, 26 Dec 2025 15:08:07 +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=nm2dbJWoOjcRmyNn27i4xIIrJUqDTKUZ7AM4tJ8lhpk=; b=jwbKLPn7ZvUlAJIf/qfOH/IDDP LLYMcMZiel9blbiyH8USj+8/Fzfl1gdpI5LbJ5rM6LDmAlsJnlbt93h8YUYE94FPj5OlmxO4AJ2w1 HpJOZOVpC4utBDXVD1ePRlzss6jlowOvQj3OwrMPhSmbFQbwiH6UnEkny7qXsaExSvVWAdUBfoD6Z FThgV7FLWbidEL763sr5+n233BQk5sUmecxb/wQN7XvjJLhm//h9pP4ROjHeQaIPE3+dljIq2esIX Tqw+1wKbCU1nCDQhrnP5Y2Kcd4Jh8OXlhns8bYLUfxmxDXVh5SFb6MReocD0cU9Ge2CFfgCZZN77z aXc+y08A==; 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.96) (envelope-from ) id 1vZ9QC-007sYB-34 for pgsql-bugs@lists.postgresql.org; Fri, 26 Dec 2025 15:08:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vZ9QA-00DkMu-2m for pgsql-bugs@lists.postgresql.org; Fri, 26 Dec 2025 15:08:03 +0000 Content-Type: multipart/mixed; boundary="===============3413174841129178906==" MIME-Version: 1.0 Subject: BUG #19363: PostgreSQL shared memory exhaustion during query execution involving views and parallel workers To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jinhui.lai@qq.com Reply-To: jinhui.lai@qq.com, pgsql-bugs@lists.postgresql.org Date: Fri, 26 Dec 2025 15:07:59 +0000 Message-ID: <19363-8dd32fc7600a1153@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 --===============3413174841129178906== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTM2MwpMb2dnZWQgYnk6ICAgICAgICAgIEppbmh1aSBMYWkKRW1haWwg YWRkcmVzczogICAgICBqaW5odWkubGFpQHFxLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE4LjEK T3BlcmF0aW5nIHN5c3RlbTogICB1YnVudHUgMjIuMDQKRGVzY3JpcHRpb246ICAgICAgICAKCkhp LCBQb3N0Z3JlU1FMIGRldmVsb3BlcnM6CgpUaGFua3MgZm9yIHJlYWRpbmcgbXkgcmVwb3J0LiBJ IG1heSBmaW5kIGEgYnVnLiBZb3UgY2FuIHJlcHJvZHVjZSBpdCBhcwpmb2xsb3dzOgoKQ1JFQVRF IFRBQkxFIHQwKGMwIFJFQUwpOwpDUkVBVEUgVEFCTEUgdDEoYzAgUkVBTCk7CkNSRUFURSBUQUJM RSB0MihjMCBSRUFMKSBXSVRIIChwYXJhbGxlbF93b3JrZXJzPTEpOwpDUkVBVEUgVEFCTEUgdDMo YzAgUkVBTCkgV0lUSCAocGFyYWxsZWxfd29ya2Vycz0yKTsKQ1JFQVRFIFZJRVcgdjAoYzAsIGMx LCBjMikgQVMgKFNFTEVDVCB0MC5jMCwgdDEuYzAsIHQyLmMwIEZST00gdDAsIHQxLCB0Mik7ClNF TEVDVCB0My5jMCBGUk9NIHQzIFdIRVJFIE5PVCBFWElTVFMgKFNFTEVDVCAxIEZST00gdjAgV0hF UkUgdDMuYzAgPQp2MC5jMCk7CkVSUk9SOiAgY291bGQgbm90IHJlc2l6ZSBzaGFyZWQgbWVtb3J5 IHNlZ21lbnQgIi9Qb3N0Z3JlU1FMLjM5NjE4OTk4ODgiIHRvCjMzNjI0MDY0IGJ5dGVzOiBObyBz cGFjZSBsZWZ0IG9uIGRldmljZQoKV2hlbiBleGVjdXRpbmcgYSBxdWVyeSB3aXRoIGEgTk9UIEVY SVNUUyBzdWJxdWVyeSByZWZlcmVuY2luZyBhIHZpZXcgdGhhdApqb2lucyBtdWx0aXBsZSB0YWJs ZXMsIFBvc3RncmVTUUwgZmFpbHMgd2l0aCBhIHNoYXJlZCBtZW1vcnkgYWxsb2NhdGlvbgplcnJv ciAoImNvdWxkIG5vdCByZXNpemUgc2hhcmVkIG1lbW9yeSBzZWdtZW50IC4uLiBObyBzcGFjZSBs ZWZ0IG9uCmRldmljZSIpLiBUaGUgaXNzdWUgYXBwZWFycyB0byBiZSByZWxhdGVkIHRvIHBhcmFs bGVsIHF1ZXJ5IGV4ZWN1dGlvbiwgYXMgaXQKb2NjdXJzIHdoZW4gb25lIG9mIHRoZSB1bmRlcmx5 aW5nIHRhYmxlcyAodDMpIGhhcyBwYXJhbGxlbF93b3JrZXJzIHNldCB0byAyLAp3aGlsZSBhbm90 aGVyIHRhYmxlICh0MikgaGFzIHBhcmFsbGVsX3dvcmtlcnMgc2V0IHRvIDEuIFRoZSBwcm9ibGVt Cm1hbmlmZXN0cyBzcGVjaWZpY2FsbHkgZHVyaW5nIHRoZSBxdWVyeSdzIGV4ZWN1dGlvbiBwaGFz ZSwgd2hlcmUgdGhlIHBsYW5uZXIKYXR0ZW1wdHMgdG8gYWxsb2NhdGUgc2hhcmVkIG1lbW9yeSBm b3IgcGFyYWxsZWwgd29ya2Vycywgc3VnZ2VzdGluZyBhCnBvc3NpYmxlIHJlc291cmNlIGxlYWsg b3IgaW5hZGVxdWF0ZSBjbGVhbnVwIG9mIHNoYXJlZCBtZW1vcnkgc2VnbWVudHMgd2hlbgpwYXJh bGxlbCBxdWVyaWVzIGludm9sdmUgdmlld3MuIFRoZSBlcnJvciBwZXJzaXN0cyBkZXNwaXRlIHN1 ZmZpY2llbnQKYXZhaWxhYmxlIHN5c3RlbSBtZW1vcnksIGluZGljYXRpbmcgYW4gaW50ZXJuYWwg UG9zdGdyZVNRTCByZXNvdXJjZQptYW5hZ2VtZW50IGlzc3VlIHJhdGhlciB0aGFuIGEgc3lzdGVt LWxldmVsIG1lbW9yeSBjb25zdHJhaW50LgoKQmVzdCByZWdhcmRzLApKaW5odWkgTGFpCgo= --===============3413174841129178906==--