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 1svnU2-00HYjm-KG for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Oct 2024 00:44:51 +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 1svnU1-007PvV-Ac for pgsql-bugs@arkaria.postgresql.org; Wed, 02 Oct 2024 00:44:49 +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 1svnU1-007PvN-1x for pgsql-bugs@lists.postgresql.org; Wed, 02 Oct 2024 00:44:49 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1svnTs-00260e-WF for pgsql-bugs@lists.postgresql.org; Wed, 02 Oct 2024 00:44:48 +0000 Received: by mail-pl1-x635.google.com with SMTP id d9443c01a7336-20b833f9b35so25514265ad.2 for ; Tue, 01 Oct 2024 17:44:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1727829880; x=1728434680; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=8F2DSqZnoj2TntkDzjMc9DRl5j7aQdqAFAXSLFySKh8=; b=GkD5hna2Hpo5vSHVBdh60Sm/CeHAqr9kB6kiPSNK9Cu8tT9MI6rXE92+AloC2jSNtI PU5zAcjWhpLppy/o5lhlBUkTBix43KF0W2KpKz2m8nMS21mw63XgXqGAIvvCsZ8ee1Ob Y2TT1TBQfW0xR6AYXGX0Lu+UJLJqqaWwWLJUD8Vk4olb/6RvJxOY1y1nxn0a8bZdWvPi xO1qLvEaeFvb5AAmFaTAQ+QyP2zU4jMxQRV41D0uTtxV1oET7kAz3FWbnGuj54N9+mX9 7o0KWUs4kHN9LQad7rIZShcOFH6O8JtNzjCKpmi8dlTW92SMAH6LsiAD24QZqlCNvSJO OruA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1727829880; x=1728434680; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=8F2DSqZnoj2TntkDzjMc9DRl5j7aQdqAFAXSLFySKh8=; b=bzW8AwRs63O1nN4hjdJCneImjlKG98AmAwgpLHUCaHBMmQ2vPib6UCBzxcS4TeZYpx iQrYfIgGqd5Reos9NthpeBfL5yvKcQdlkPtX/g6mI2IYnsoQlJ5UvdVeyAKxOFQLGfG/ qEgifJ1axbe1SznC4tuXmoj1nKSdS5ArRStA40+2pCweiE+Z4ZF1U4WpV47EKgjdyzAS vKvNAkaorgZliGDXL/fA2P93CYd4JJWQSmATP05hA6yvzZxBLIVOBKKKxN63C75AVijT G+l2D7T5OAw6Fec4I8KZppXqKXBO0YA+vsdhIpprPtaMei4HaRFN4P6zxAfjU5koNBOu DfAw== X-Forwarded-Encrypted: i=1; AJvYcCVX/ZnENE0CWaaf0ak2QFtdBp9ul1bkrBzRnaf2T+IlI+tlnuXVQk9R4XnoInO6UYssrTR+igPzjcQY@lists.postgresql.org X-Gm-Message-State: AOJu0YxIsLL/NTuSeC1/r9jEaHlm88I4FpmB9TncV/GbWSSK9HYnRLMF oRtQVnivZnH6C7ZCtGawJLeEVPZ5Mreb1Uv/0AG/5mqH72T74n4V X-Google-Smtp-Source: AGHT+IEj9GLI6rwSz/jaMlIUmRrGZwN43NmIVd/V7HLErvyCKVzncT5NjPhzf/o1GlFMjjfWsN2Rig== X-Received: by 2002:a17:902:cec4:b0:20b:6616:6b86 with SMTP id d9443c01a7336-20bc5a8907dmr14563615ad.61.1727829880028; Tue, 01 Oct 2024 17:44:40 -0700 (PDT) Received: from [192.168.1.49] (cm-171-100-240-255.revip10.asianet.co.th. [171.100.240.255]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-20b37e576e3sm75530845ad.261.2024.10.01.17.44.37 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 01 Oct 2024 17:44:39 -0700 (PDT) Message-ID: <6785e9e8-4c64-41b0-9e72-c13d1822b599@gmail.com> Date: Wed, 2 Oct 2024 07:44:35 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker To: Craig Milhiser , Thomas Munro Cc: Tom Lane , pgsql-bugs@lists.postgresql.org References: <2878480.1727017360@sss.pgh.pa.us> Content-Language: en-US From: Andrei Lepikhov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2/10/2024 02:12, Craig Milhiser wrote: > > Since you're building from source, you could try applying the patch > >posted by Andrei Lephikov: > > > https://www.postgresql.org/message-id/7d763a6d-fad7-49b6-beb0-86f99ce4a6eb%40postgrespro.ru > > This did not work for me. I am running out of memory. Can you provide an explain of this query? Also, can you remove unnecessary details from the query text like temporary view or CASE .. WHEN construction, if the OOM still reproduces. -- regards, Andrei Lepikhov