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
-
Limit Parallel Hash's bucket array to MaxAllocSize.
- 86a2218eb00e 11.0 landed
-
Allow for parallel execution whenever ExecutorRun() is done only once.
- 691b8d59281b 10.0 cited