On Wed, Aug 7, 2013 at 6:41 PM, liuyuanyuan wrote:
> **
>
>
> 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 there's no way to s
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 wrote:
> liuyuanyuan wrote:
>>> By
On Wed, Aug 7, 2013 at 3:56 PM, Albe Laurenz 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 can't migrate BL
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 g
lease 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 wrote
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 wrote:
Hi,
On 6 Srpen 2013, 9:12, liuyuanyuan wrote:
> Error det
On Tue, Aug 6, 2013 at 7:04 AM, Tomas Vondra 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 me.
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
>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, ple
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
10 matches
Mail list logo
