Tracking down performance issue

From: Ken Geis <kgeis(at)speakeasy(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Tracking down performance issue
Date: 2004-04-13 00:17:31
Message-ID: 407B319B.7000400@speakeasy.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Browse pgsql-performance by date

  From Date Subject
Next Message Pailloncy Jean-Gérard 2004-04-13 11:12:36 Re: Index Backward Scan fast / Index Scan slow !
Previous Message Tom Lane 2004-04-12 21:23:46 Re: Index Backward Scan fast / Index Scan slow !