Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres batch write very slow - what to do - Mailing list pgsql-performance

From femski
Subject Re: Postgres batch write very slow - what to do
Date
Msg-id 9453712.post@talk.nabble.com
Whole thread Raw
In response to Re: Postgres batch write very slow - what to do  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: Postgres batch write very slow - what to do  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Postgres batch write very slow - what to do  (femski <hypertree@yahoo.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Postgres batch write very slow - what to do
Next
From: Alvaro Herrera
Date:
Subject: Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3