pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ken Geis <kgeis@speakeasy.org>
To: pgsql-performance@postgresql.org
Subject: Tracking down performance issue
Date: Mon, 12 Apr 2004 17:17:31 -0700
Message-ID: <407B319B.7000400@speakeasy.org> (raw)

I'm running 7.4.2 on an older Linux box (450MHzAMD K-6-III, 450M RAM) 
running kernel 2.6.5.  My client is a Java/JDBC program on Windows.

I'm having trouble seeing where the bottleneck in my performance is. 
The client uses about 30% CPU.  The server uses 70% CPU plus 1.5% I/O 
wait.  The I/O wait is very low because I'm doing a PK index scan where 
the index and data are on different disks and the table is clustered on 
the PK index.  The network is 100Mb, and it's at 7% of capacity.

I tried making the client operate on two threads on two database 
connections.  That bumped the server utilization to 80% and barely 
changed the I/O wait.  The throughput decreased by a third.

The only thing I can think of is memory bandwidth.  Does anyone have 
tips on how I can investigate more?




Message-ID: <407B319B.7000400@speakeasy.org>
Permalink:  ../407B319B.7000400@speakeasy.org/
Also on:    postgresql.org/message-id/407B319B.7000400@speakeasy.org

 · 

reply

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: kgeis@speakeasy.org
  Subject: Re: Tracking down performance issue
  In-Reply-To: <407B319B.7000400@speakeasy.org>

* 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