David Rowley <david.rowley@2ndquadrant.com> writes:
> On 23 September 2015 at 04:48, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> andreas-postgresql@creative-memory.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