| 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: | Whole Thread | Raw Message | 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. |