From: | sachin kotwal <kotsachin(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: inserting huge file into bytea cause out of memory |
Date: | 2013-08-06 12:36:51 |
Message-ID: | 1375792611005-5766503.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>I got a out of memory problem, when I tried to insert a binary file (256MB)
to bytea column;
>I want to get a way to insert files (vary from 1byte to 2GB) or byte array
or binary stream into
>PostgreSQL bytea field, never cause out of memory. Fellowed by the details.
>Anybody know about this, please write to me.
>Thanks in advance!
Maximum data size allowed to store in BYTEA data types is 1GB.
so you can store data less than 1 GB.
When you are inserting system asking for more data than your expectation. by
this message-
"Details:Failed on request of size 268443660"
so please check anything wrong elsewhere in your code.
Also check free memory of your system, at the time of insertion.
http://www.microolap.com/products/connectivity/postgresdac/help/TipsAndTricks/ByteaVsOid.htm
-----
Thanks and Regards,
Sachin Kotwal
NTT-DATA-OSS Center (Pune)
--
View this message in context: http://postgresql.1045698.n5.nabble.com/inserting-huge-file-into-bytea-cause-out-of-memory-tp5766466p5766503.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | edlef | 2013-08-06 13:56:48 | postgre restarts in short period |
Previous Message | KONDO Mitsumasa | 2013-08-06 11:42:13 | Re: Bottlenecks with large number of relation segment files |