Re: inserting huge file into bytea cause out of memory

From: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
To: "liuyuanyuan" <liuyuanyuan(at)highgo(dot)com(dot)cn>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: inserting huge file into bytea cause out of memory
Date: 2013-08-06 14:04:57
Message-ID: 60fea0d894b294b3f3b1a74d8cd0104d.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Try this as postgres (or the user you run the database as):

ulimit -v

and as root

sysctl.overcommit_memory

These are the

What limits do you have in place options that bite me most often.

Tomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message edlef 2013-08-06 14:15:19 Re: postgre restarts in short period
Previous Message Klaus Ita 2013-08-06 14:03:44 Re: postgre restarts in short period