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 1rCW0N-00GFNk-18 for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Dec 2023 02:26:47 +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 1rCW0L-00AAUv-IU for pgsql-bugs@arkaria.postgresql.org; Mon, 11 Dec 2023 02:26:45 +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.94.2) (envelope-from ) id 1rCW0L-00AAUn-63 for pgsql-bugs@lists.postgresql.org; Mon, 11 Dec 2023 02:26:45 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rCW0H-009o2q-Uj for pgsql-bugs@lists.postgresql.org; Mon, 11 Dec 2023 02:26:43 +0000 Received: from [10.10.20.27] (node-16ll.pool-118-172.dynamic.totinternet.net [118.172.215.169]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) (Authenticated sender: a.lepikhov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 30D2EE21019; Mon, 11 Dec 2023 05:26:36 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1702261598; bh=JyuyzkZLClZFMeeJ36bYSC1zUjICCVFoYXWpKvlGc5o=; h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From: In-Reply-To:From; b=wU/LaSfXe/2wRoWmtgDJWTS4xoKX9A0jJDtOEeX2UTIBwEHZPPY4PNq3sGdbTpagO OHc7/6NeeyWx7Is35oCE7NUQoNJruQTMD/5Hc9zhry0QA4XrtO9EpRkx5Hv78aOREF 4tVv57I37OQSI0ix5aB1orUvS5PMHRJhz84Co6eRoifdM/ZPrsI4JHGKE9GfZrYXgs m0F7jtgYCslKg8uxWrXcTX+QOrWQFGgQvf7TJPoS6n98fDnI7dn/41UgFs7ouxOmeE GMXoZWH7vjGP/yhJ7iYbWE/DsR2o2g8dMvpA/4FVUTREATfgKKPSgudkrDSUTsxNm+ vZLE7KpTcLu+Q== Message-ID: <5192824e-370f-432e-918f-6b62cead4ae3@postgrespro.ru> Date: Mon, 11 Dec 2023 09:26:33 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #16925: ERROR: invalid DSA memory alloc request size 1073741824 CONTEXT: parallel worker To: Thomas Munro Cc: PostgreSQL mailing lists , "a.rybakina" References: <16925-ec96d83529d0d629@postgresql.org> <9277414b-dbce-4a32-8aff-642e399e23e5@postgrespro.ru> Content-Language: en-US From: Andrei Lepikhov Organization: Postgres Professional In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/12/2023 09:41, Thomas Munro wrote: > On Wed, Dec 6, 2023 at 5:46 PM Andrei Lepikhov > wrote: >> This bug still annoyingly interrupts the queries of some clients. Maybe >> complete this work? > > Ugh, sorry. We had a report, a repro and a candidate patch a couple > of years ago, but I somehow completely forgot about it. I have now > added a CF entry (#4689). Thanks. I think the Parallel Hash Join code is worth discovering extreme cases anyway, but in that case, we have quite a clear bug and must fix it. -- regards, Andrei Lepikhov Postgres Professional