Re: Postgres batch write very slow - what to do

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.