Home > mailing lists

Re: Out of Memory during Insert - Mailing list pgsql-general

From	Thom Brown
Subject	Re: Out of Memory during Insert
Date	March 24, 2010 13:09:54
Msg-id	bddc86151003240609o1161390t3146949ca0a3d4c3@mail.gmail.com Whole thread Raw
In response to	Out of Memory during Insert (yue peng <pengyuebupt@gmail.com>)
List	pgsql-general

Tree view

On 24 March 2010 10:57, yue peng <pengyuebupt@gmail.com> wrote:

Is there any other ways to still insert same amount of data and avoid this OOM error ?

I'd expect COPY to be the most effective way of bulk loading data into a database. http://www.postgresql.org/docs/current/static/sql-copy.html

Or do inserts in smaller batches.

Do you happen to have any triggers or constraints on the table?

Regards

Thom

pgsql-general by date:

From: yue peng
Date: 24 March 2010, 12:25:08
Subject: Out of Memory during Insert

From: "Albe Laurenz"
Date: 24 March 2010, 13:27:50
Subject: Re: Concatenate

Re: Out of Memory during Insert - Mailing list pgsql-general

Previous

Next