From: femski <hypertree@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres batch write very slow - what to do
Date: Tue, 13 Mar 2007 05:56:23 -0700 (PDT)
Message-ID: <9453712.post@talk.nabble.com> (raw)
In-Reply-To: <45F685B7.5040001@enterprisedb.com>
References: <9452092.post@talk.nabble.com>
<45F685B7.5040001@enterprisedb.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: hypertree@yahoo.com
Subject: Re: Postgres batch write very slow - what to do
In-Reply-To: <9453712.post@talk.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox