On 24 March 2010 10:57, yue peng <pengyuebupt@xxxxxxxxx> 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
