Horton

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

Craig Milhiser <craig@milhiser.com>

View thread View on postgr.es
From: Craig Milhiser <craig@milhiser.com>
To: Andrei Lepikhov <lepihov@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Thomas Munro <thomas.munro@gmail.com>, pgsql-bugs@lists.postgresql.org
Date: 2024-10-15T16:43:52Z
Lists: pgsql-bugs 
I applied the patch for the parallel hash and ran that against my
production data. The query worked with parallel workers. That patch was
applied on top of the earlier patch for the invalid Susa memory alloc that
started this thread.

From my view as a user, these are both fixed and can be marked as such.  We
will wait for the patches to role through the release cycles.

If you change the patch and need another test with real data please let me
know.

Thank you for your time and effort on these issues.

Commits

  1. Fix extreme skew detection in Parallel Hash Join.