I am runing Postgres 8.2 on OpenSuse 10.2 with latest jdbc driver. I moved the app to be collocated with the server. Oracle takes 60 sec. Postgres 275 sec. For 4.7 million rows. There are 4 CPUs on the server and one is runing close to 100% during inserts. Network history shows spikes of upto 60% of the bandwidth (Gnome System monitor graph). I have a gigabit card - but should not enter into picture since its on local host. thanks, -Sanjay -- View this message in context: http://www.nabble.com/Postgres-batch-write-very-slow---what-to-do-tf3395195.html#a9453712 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
