Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-07 Thread Albe Laurenz
liuyuanyuan wrote: By the way, my project is about migrating Oracle data of BLOB type to PostgreSQL database. The out of memory error occurred between migrating Oracle BLOB to PostgreSQL bytea. Another question, if I can't migrate BLOB to bytea, how about oid type ? Large Objects (I guess

Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-07 Thread Michael Paquier
On Wed, Aug 7, 2013 at 3:56 PM, Albe Laurenz laurenz.a...@wien.gv.at wrote: liuyuanyuan wrote: By the way, my project is about migrating Oracle data of BLOB type to PostgreSQL database. The out of memory error occurred between migrating Oracle BLOB to PostgreSQL bytea. Another question, if I

Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-07 Thread liuyuanyuan
liuyuanyuan From: Michael Paquier Date: 2013-08-07 15:26 To: Albe Laurenz CC: liuyuanyuan; Chris Travers; tv; pgsql-general Subject: Re: [GENERAL] inserting huge file into bytea cause out of memory On Wed, Aug 7, 2013 at 3:56 PM, Albe Laurenz laurenz.a...@wien.gv.at wrote: liuyuanyuan wrote

Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-07 Thread Chris Travers
On Wed, Aug 7, 2013 at 6:41 PM, liuyuanyuan liuyuany...@highgo.com.cnwrote: ** Thanks for your last reply! I've test Large Object ( oid type ), and it seems better on out of memory. But, for the out of memory problem of bytea, we really have no idea to solve it ? Why

[GENERAL] inserting huge file into bytea cause out of memory

2013-08-06 Thread liuyuanyuan
Hello everyone! 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

Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-06 Thread sachin kotwal
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

Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-06 Thread Tomas Vondra
Hi, On 6 Srpen 2013, 9:12, liuyuanyuan wrote: Error detail: org.postgresql.util.PSQLException: Error: out of memory Details:Failed on request of size 268443660. Seems like an issue with the OS, not with PostgreSQL, to me. What OS and HW are you using? How much memory you have and do you

Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-06 Thread Chris Travers
On Tue, Aug 6, 2013 at 7:04 AM, Tomas Vondra t...@fuzzy.cz wrote: Hi, On 6 Srpen 2013, 9:12, liuyuanyuan wrote: Error detail: org.postgresql.util.PSQLException: Error: out of memory Details:Failed on request of size 268443660. Seems like an issue with the OS, not with PostgreSQL, to

Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-06 Thread liuyuanyuan
Aug 7, 2013 From: Chris Travers Date: 2013-08-07 00:49 To: Tomas Vondra CC: liuyuanyuan; pgsql-general Subject: Re: [GENERAL] inserting huge file into bytea cause out of memory On Tue, Aug 6, 2013 at 7:04 AM, Tomas Vondra t...@fuzzy.cz wrote: Hi, On 6 Srpen 2013, 9:12, liuyuanyuan wrote

Re: [GENERAL] inserting huge file into bytea cause out of memory

2013-08-06 Thread liuyuanyuan
write to me. Thanks in advance ! Liu Yuanyuan Aug 7, 2013 liuyuanyuan From: Chris Travers Date: 2013-08-07 00:49 To: Tomas Vondra CC: liuyuanyuan; pgsql-general Subject: Re: [GENERAL] inserting huge file into bytea cause out of memory On Tue, Aug 6, 2013 at 7:04 AM, Tomas Vondra t...@fuzzy.cz