Re: ERROR: invalid memory alloc request size 1073741824 - Mailing list pgsql-hackers

From David Rowley
Subject Re: ERROR: invalid memory alloc request size 1073741824
Date
Msg-id CAKJS1f8s6DUVysnep-C73Jik1L1u1enT88uVFe1TZN_91K6jQw@mail.gmail.com
Whole thread Raw
In response to ERROR: invalid memory alloc request size 1073741824  (Suhal Vemu <suhal@cropextechnology.com>)
List pgsql-hackers
On 6 April 2018 at 22:06, Suhal Vemu <suhal@cropextechnology.com> wrote:
> ERROR:
> BEGIN
> CREATE TABLE
> ERROR:  invalid memory alloc request size 1073741824

Can we see the full CREATE TABLE command?

Are you able to get the CREATE TABLE to succeed if you try removing
some combination of columns? Start with the PostGIS ones. Are you able
to determine if it's a single column or type which is causing the
issue?

Which PostgreSQL version? the output of SELECT version(); would be good.

> Please note that this email, including any attachments, is intended solely
> for the individual (s) or entity (ies) to whom they are addressed and may
> contain information that is private, confidential and privileged. In case
> you are not the intended recipient, request you to notify the sender by
> reply mail and delete this email, including any copies or attachments from
> your system. Any unauthorized dissemination, disclosure and/or use of the
> contents of this communication to anyone is strictly prohibited and
> punishable by law.

This mailing list is public.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: [HACKERS] Runtime Partition Pruning
Next
From: Tom Kincaid
Date:
Subject: Re: pgsql: New files for MERGE