On 24 March 2010 10:57, yue peng <pengyuebupt(at)gmail(dot)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