Would it help if I moved this particular bit of code on to the server side as a server side function? Would there be a significant increase in speed/efficiency? Thanks in advance. --Arsalan > break up you insert into several trunks. > > > Arsalan Zaidi wrote: > > > Hi. > > > > At one point in my program, I was inserting a large number of rows > > (~600,000) using a prepared statement. Here are some things I noticed. > > > > 1. It's very slow! :-) > > 2. Initially, the cpu monitor shows a high level of cpu utilisation, but > > this slowly drops off with a blip every second or so. Basically, things slow > > down as the process chugs along. > > 3. I eventually get a java.Lang.OutOfMemory exception after approx 1:00 - > > 1:30 hrs. > > > > I tried running the JVM with heap size set to 50 Mbytes. I still get the out > > of mem error. > > > > I can't use the 'load' command instead of individual inserts. > > > > Is there a faster/better way? Any ideas on how I can get rid of the out of > > mem errors? > > > > Thanks in advance > > > > --Arsalan > > ------------------------------------------------- > > WAR IS PEACE > > FREEDOM IS SLAVERY > > IGNORANCE IS STRENGTH > > --1984 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
