Re: Rather large LA

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


24 :)

4 x Intel Xeon-NehalemEX E7540-HexCore [2GHz]

On 6 Sep 2011, at 20:07, Alan Hodgson wrote:

> 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 Craig James 2011-09-06 19:17:50 Re: how fast index works?
Previous Message Alan Hodgson 2011-09-06 19:07:56 Re: Rather large LA