Re: Postgres batch write very slow - what to do

From: femski <hypertree(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres batch write very slow - what to do
Date: 2007-03-13 12:56:23
Message-ID: 9453712.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2007-03-13 13:09:45 Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3
Previous Message Merlin Moncure 2007-03-13 12:40:49 Re: Postgres batch write very slow - what to do