| From: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Slow application response on lightly loaded server? |
| Date: | 2012-07-17 16:27:23 |
| Message-ID: | CANPAkgtV-0r=ZqGGJm6mvi1CZNvBJSWdfFX2bjFOQJMebr035Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
We're seeing slow application performance on a PostgreSQL 9.1 server which
appears to be relatively lightly loaded. Some graphs from pgstatview are
at http://www2.uptimeforce.com/pgstatview/e35ba4e7db0842a1b9cf2e10a4c03d91/
These cover approximately 40 minutes, during which there was some activity
from a web application and two bulk loads in process.
The machine running the bulk loads (perl scripts) is also running at about
70% idle with very little iowait. That seems to suggest network latency to
me.
Am I missing something in the server stats that would indicate a problem?
If not, where should I look next?
__________________________________________________________________________________
*Mike Blackwell | Technical Analyst, Distribution Services/Rollout
Management | RR Donnelley*
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike(dot)Blackwell(at)rrd(dot)com
http://www.rrdonnelley.com
<http://www.rrdonnelley.com/>
* <Mike(dot)Blackwell(at)rrd(dot)com>*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2012-07-17 16:35:03 | Re: Slow application response on lightly loaded server? |
| Previous Message | Jeff Janes | 2012-07-17 16:24:37 | Re: very very slow inserts into very large table |