Re: Rather large LA

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-performance(at)postgresql(dot)org
Cc: Richard Shaw <richard(at)aggress(dot)net>
Subject: Re: Rather large LA
Date: 2011-09-06 19:07:56
Message-ID: 201109061207.56559.ahodgson@simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Shaw 2011-09-06 19:11:10 Re: Rather large LA
Previous Message Anibal David Acosta 2011-09-06 18:31:33 how fast index works?