Horton

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

Andrei Lepikhov <lepihov@gmail.com>

View thread View on postgr.es
From: Andrei Lepikhov <lepihov@gmail.com>
To: Craig Milhiser <craig@milhiser.com>, Thomas Munro <thomas.munro@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-bugs@lists.postgresql.org
Date: 2024-10-02T00:44:35Z
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

Commits

  1. Fix extreme skew detection in Parallel Hash Join.