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