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

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Cc: Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, Alexey Ermakov <alexey(dot)ermakov(at)dataegret(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker
Date: 2024-03-04 00:20:21
Message-ID: CA+hUKGLCor9+umOJxNuMH5Uqno82c3Douk0q78WAgW91sKVgJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Mar 4, 2024 at 1:11 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> ... This morning I've been
> wondering about a highly targeted solution to that: could we recognise
> this condition cheaply, and then activate a special case that spills a
> *bucket* to disk? That is, a problem bucket that is indivisible by
> hashing because all the hash values are the same. Or something like
> that.

(One of the main problems being how to manage the match bits for outer
joins, a big problem also for idea #2. But maybe it's somehow more
tractable there, I dunno. I'd need vastly more coffee to have any
idea...)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2024-03-04 00:40:01 Re: Record returning function accept not matched columns declaration
Previous Message Thomas Munro 2024-03-04 00:11:47 Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker