Re: BUG #15225: [XX000] ERROR: invalid DSA memory alloc request size 1073741824 / Where: parallel worker

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Frits Jalvingh <jal@etc.to>
Cc: Thomas Munro <thomas.munro@enterprisedb.com>, pgsql-bugs@lists.postgresql.org
Date: 2018-06-06T16:23:22Z
Lists: pgsql-bugs
Frits Jalvingh <jal@etc.to> writes:
> The "good" news is that this effect is apparently caused by something else.
> I fired those statements through an IDE (IntelliJ) written in Java and
> using jdbc. There seems to be something odd going on in there, because when
> I paste the query in psql then the effect with and without explain looks
> the same: 3 processes of which 2 "parallel workers" doing enormous amounts
> of I/O at 50..90% CPU. I will try to find out what easter egg in either
> that IDE or the JDBC driver causes this 8-/.

Ah.  Something about query parameterization, is my bet.

			regards, tom lane


Commits

  1. Limit Parallel Hash's bucket array to MaxAllocSize.

  2. Allow for parallel execution whenever ExecutorRun() is done only once.