Re: Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker - Mailing list pgsql-bugs

From Andrei Lepikhov
Subject Re: Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker
Date
Msg-id 6785e9e8-4c64-41b0-9e72-c13d1822b599@gmail.com
Whole thread Raw
In response to Re: Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker  (Craig Milhiser <craig@milhiser.com>)
Responses Re: Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker
List pgsql-bugs
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
<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




pgsql-bugs by date:

Previous
From: Andrei Lepikhov
Date:
Subject: Re: BUG #18643: EXPLAIN estimated rows mismatch
Next
From: ming wei tan
Date:
Subject: Re: BUG #18643: EXPLAIN estimated rows mismatch