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

From: Andrei Lepikhov <lepihov(at)gmail(dot)com>
To: Craig Milhiser <craig(at)milhiser(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Reference to - BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker
Date: 2024-10-02 00:44:35
Message-ID: 6785e9e8-4c64-41b0-9e72-c13d1822b599@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message ming wei tan 2024-10-02 02:04:36 Re: BUG #18643: EXPLAIN estimated rows mismatch
Previous Message Takeshi Ideriha 2024-10-02 00:36:53 Re: BUG #18641: Logical decoding of two-phase commit fails with TOASTed default values