| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Suhal Vemu <suhal(at)cropextechnology(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: ERROR: invalid memory alloc request size 1073741824 |
| Date: | 2018-04-06 14:04:34 |
| Message-ID: | 22266.1523023474@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Suhal Vemu <suhal(at)cropextechnology(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2018-04-06 14:13:12 | Re: pgsql: Foreign keys on partitioned tables |
| Previous Message | Alvaro Herrera | 2018-04-06 14:00:16 | Re: Vacuum: allow usage of more than 1GB of work mem |