Re: Postgres batch write very slow - what to do

Ok, I turned off XDMCP and network bandwidth utilization dropped to less than
5%.
Timings remained the same.

Curiously five times faster time for Oracle came from a client running on a
different host than the server.
To make things worse for Postgres, when I replace "hostname" in jdbc string
to "localhost" or 127.0.0.1
it runs another 60% slower (446 sec vs 275 sec). Strange.

Before I take this discussion to jdbc list, why is CPU utilization 100%
during insert ? could that be a bottleneck. How to eliminate it ? These are
Intel WordCrest 5110 Xeon cores.

thank you

-Sanjay

femski wrote:
>
> 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#a9473692
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.