From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
---|---|
To: | Frits Jalvingh <jal(at)etc(dot)to> |
Cc: | Dilip Kumar <dilipbalaut(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15225: [XX000] ERROR: invalid DSA memory alloc request size 1073741824 / Where: parallel worker |
Date: | 2018-06-09 05:06:05 |
Message-ID: | CAEepm=2bMJTh=fuZFi2MbiKXUKTrF+Z7TVunTLJZP9c3ocaEgA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, Jun 7, 2018 at 1:00 PM, Thomas Munro
<thomas(dot)munro(at)enterprisedb(dot)com> wrote:
>> ERROR: invalid DSA memory alloc request size 1073741824
>
> Here is a proposed fix
Here is a tidier version that I'd like to commit before beta2, if
there are no objections. I've added this to the PostgreSQL 11 open
items page. Here's a simple way to reach the error with default
settings in unpatched master (given enough memory and disk):
create table foo (i int);
insert into foo select generate_series(1, 128000000);
set work_mem = '2GB';
select count(*) from foo f1 join foo f2 using (i);
--
Thomas Munro
http://www.enterprisedb.com
Attachment | Content-Type | Size |
---|---|---|
0001-Limit-Parallel-Hash-s-bucket-array-to-MaxAllocSize.patch | application/octet-stream | 1.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2018-06-09 10:01:27 | BUG #15235: Getting failure message "Restore archive operation failed" while restoring database |
Previous Message | Maxim Boguk | 2018-06-08 12:08:43 | Re: BUG #15233: Error in estimation leads to very bad parralel plan in simple 2 table join. |