| From: | liuyuanyuan <liuyuanyuan(at)highgo(dot)com(dot)cn> |
|---|---|
| To: | tv <tv(at)fuzzy(dot)cz> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: inserting huge file into bytea cause out of memory |
| Date: | 2013-08-07 02:01:30 |
| Message-ID: | 201308071001306946097@highgo.com.cn |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, Tomas Vondra!
Thanks for all of your help!
My test PC is Win7 (64-bit), and equipped with 8GB of memory.
In this java project, I configured VM option as:
-D java.security.policy=applet.policy -Xms1280m -Xmx1536m.
Any thing you want to know, just write to me!
Best Regard!
Liu Yuanyuan
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 <tv(at)fuzzy(dot)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 me.
What OS and HW are you using? How much memory you have and do you have
some user limits in place? For example Linux uses ulimit and some kernel
parameters to limit how much memory can be allocated by a process.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | liuyuanyuan | 2013-08-07 02:48:04 | Re: inserting huge file into bytea cause out of memory |
| Previous Message | Sergey Konoplev | 2013-08-07 00:24:52 | Re: Hierarchical numeric data type |