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

From Tom Lane
Subject Re: ERROR: invalid memory alloc request size 1073741824
Date
Msg-id 22266.1523023474@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: invalid memory alloc request size 1073741824  (Suhal Vemu <suhal@cropextechnology.com>)
List pgsql-hackers
Suhal Vemu <suhal@cropextechnology.com> writes:
> so, i need to import the tif file of memory greater than 500mb at least .

If you're trying to cram that into a single bytea field, it's unsurprising
that it fails.  PG is not designed to work with table rows (let alone
individual fields) that exceed some not-very-large fraction of 1GB.
You could stream the value into a "large object", perhaps.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Vacuum: allow usage of more than 1GB of work mem
Next
From: Robert Haas
Date:
Subject: Re: pgsql: Foreign keys on partitioned tables