From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Slow application response on lightly loaded server? |
Date: | 2012-07-17 16:35:03 |
Message-ID: | CAOR=d=3mbyZcK5RsJchpF4mOQ7g2V9BerXKiG92vyvhJuGdzBw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Tue, Jul 17, 2012 at 10:27 AM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> wrote:
> 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?
I'd run vmstat and look for high cs or int numbers (100k and above) to
see if you're maybe seeing an issue with that. A lot of times a
"slow" server is just too much process switching. But yeah, the
graphs you've posted don't seem overly bad.
From | Date | Subject | |
---|---|---|---|
Next Message | Claudio Freire | 2012-07-17 16:55:49 | Re: very very slow inserts into very large table |
Previous Message | Mike Blackwell | 2012-07-17 16:27:23 | Slow application response on lightly loaded server? |