pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Cc: Richard Shaw <richard@aggress.net>
Subject: Re: Rather large LA
Date: Tue, 6 Sep 2011 12:07:56 -0700
Message-ID: <201109061207.56559.ahodgson@simkin.ca> (raw )
In-Reply-To: <9BFA2771-CA9B-4EEF-B671-78FF67F749C6@aggress.net >
References: <F757E48F-2B4F-496D-951B-B04ED98F8FD6@aggress.net >
<201109051305.07010@hal.medialogik.com >
<9BFA2771-CA9B-4EEF-B671-78FF67F749C6@aggress.net >
On September 5, 2011 03:36:09 PM you wrote:
> After Restart
>
> procs -----------memory---------- ---swap-- -----io---- --system--
> -----cpu------ r b swpd free buff cache si so bi bo in
> cs us sy id wa st 2 34 2332 5819012 75632 25855368 0 0 89
> 42 0 0 7 5 85 3 0 4 39 2332 5813344 75628 25833588 0 0
> 5104 324 5480 27047 3 1 84 11 0 2 47 2332 5815212 75336 25812064
> 0 0 4356 1664 5627 28695 3 1 84 12 0 2 40 2332 5852452 75340
> 25817496 0 0 5632 828 5817 28832 3 1 84 11 0 1 45 2332
> 5835704 75348 25817072 0 0 4960 1004 5111 25782 2 1 88 9 0 2
> 42 2332 5840320 75356 25811632 0 0 3884 492 5405 27858 3 1
> 88 8 0 0 47 2332 5826648 75348 25805296 0 0 4432 1268 5888
> 29556 3 1 83 13 0
>
> avg-cpu: %user %nice %system %iowait %steal %idle
> 3.26 0.00 1.69 25.21 0.00 69.84
>
> Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz
> avgqu-sz await svctm %util sda 0.50 45.00 520.00
> 2.50 8316.00 380.00 16.64 71.70 118.28 1.92 100.10 sda1
> 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
> 0.00 0.00 0.00 sda2 0.50 45.00 520.00 2.50 8316.00
> 380.00 16.64 71.70 118.28 1.92 100.10 sda3 0.00
> 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
> sdb 0.00 196.50 0.00 10.50 0.00 1656.00 157.71
> 0.01 0.67 0.52 0.55 sdb1 0.00 196.50 0.00 10.50
> 0.00 1656.00 157.71 0.01 0.67 0.52 0.55
>
> avg-cpu: %user %nice %system %iowait %steal %idle
> 3.97 0.00 1.71 20.88 0.00 73.44
Yeah 20% I/O wait I imagine feels pretty slow. 8 cores?
view thread (22+ messages) latest in thread
Message-ID: <201109061207.56559.ahodgson@simkin.ca>
Permalink: ../201109061207.56559.ahodgson@simkin.ca/
Also on: postgresql.org/message-id/201109061207.56559.ahodgson@simkin.ca
copy link · copy postgr.es
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: ahodgson@simkin.ca, richard@aggress.net
Subject: Re: Rather large LA
In-Reply-To: <201109061207.56559.ahodgson@simkin.ca>
* 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