| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
| Cc: | andreas-postgresql(at)creative-memory(dot)de, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #13633: ERROR: invalid memory alloc request size |
| Date: | 2015-09-22 23:28:34 |
| Message-ID: | 15624.1442964514@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> writes:
> On 23 September 2015 at 04:48, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> andreas-postgresql(at)creative-memory(dot)de writes:
>>> ERROR: invalid memory alloc request size 1073741824
>> FWIW, I could not reproduce this on the basis of the supplied information,
> This seems related to this
> http://www.postgresql.org/message-id/9A28C8860F777E439AA12E8AEA7694F8010F6F3F@BPXM15GP.gisp.nec.co.jp
> work_mem, I believe, must be higher than 1GB to trigger this.
Hmm ... yeah, that issue is a possible explanation if work_mem is high
enough and it's trying to use a hash join.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2015-09-22 23:47:11 | Re: [BUGS] BUG #13632: violation de l'intégrité référentielle |
| Previous Message | David Rowley | 2015-09-22 22:57:25 | Re: BUG #13633: ERROR: invalid memory alloc request size |