[Postgres-xl-general] Invalid memory alloc request size

Aaron Jackson ajackson at revionics.com
Wed Sep 24 21:06:11 PDT 2014


I'll let you know as soon as I've tested it.

Aaron
________________________________
From: Mason Sharp [msharp at translattice.com]
Sent: Wednesday, September 24, 2014 8:48 PM
To: Aaron Jackson
Cc: Pavan Deolasee; postgres-xl-general at lists.sourceforge.net
Subject: Re: [Postgres-xl-general] Invalid memory alloc request size


On Wed, Sep 24, 2014 at 6:31 PM, Mason Sharp <msharp at translattice.com<mailto:msharp at translattice.com>> wrote:


On Mon, Sep 22, 2014 at 9:49 AM, Aaron Jackson <ajackson at revionics.com<mailto:ajackson at revionics.com>> wrote:
Yes, it appears (or at least is highly correlated) to be related to the size of the table - 60M rows  So, I dumped the table, truncated the table, added the node and then reloaded - no issues.

Do you mind retrying with a smaller work_mem size? I believe you said you set yours for 1GB. When redistributing, it will use a size of work_mem internally. 1 GB happens to be 1073741824 bytes, and that error message gets triggered at 1GB - 1 byte.

I think the fix here is for us to cap this to be below 1 GB if work_mem is too high.

Thanks,



Please try attached patch and let me know if it helps, then I will commit it.

Thanks,

Mason
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140925/c0921aef/attachment.htm>


More information about the postgres-xl-general mailing list