From: Merlin Moncure <mmoncure@gmail.com>
To: femski <hypertree@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres batch write very slow - what to do
Date: Thu, 15 Mar 2007 06:22:19 +0530
Message-ID: <b42b73150703141752q64ddebc2mb53c501047d0b7b6@mail.gmail.com> (raw)
In-Reply-To: <9473692.post@talk.nabble.com>
References: <9452092.post@talk.nabble.com>
<45F685B7.5040001@enterprisedb.com>
<9453712.post@talk.nabble.com>
<9473692.post@talk.nabble.com>
On 3/14/07, femski <hypertree@yahoo.com> wrote:
>
> 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.
when loading to oracle, does it utilize more than one core? istm your
best bet would be to split load process to 4+ backends...
merlin
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: mmoncure@gmail.com, hypertree@yahoo.com
Subject: Re: Postgres batch write very slow - what to do
In-Reply-To: <b42b73150703141752q64ddebc2mb53c501047d0b7b6@mail.gmail.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