Re: Hardware spec
От | Willo van der Merwe |
---|---|
Тема | Re: Hardware spec |
Дата | |
Msg-id | 46E00F9C.40704@mirasol.co.za обсуждение исходный текст |
Ответ на | Re: Hardware spec (Florian Weimer <fweimer@bfk.de>) |
Список | pgsql-performance |
Florian Weimer wrote: > You need to run "vmstat 10" (for ten-second averages) and report a > couple of lines. > procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 1 0 61732 47388 27908 3431344 0 0 10 65 1 4 17 2 80 1 5 0 61732 37052 28180 3431956 0 0 14 987 2320 2021 38 4 56 2 1 0 61620 43076 28356 3432256 0 0 0 367 1691 1321 28 3 67 1 3 0 61620 37620 28484 3432740 0 0 0 580 4088 6792 40 5 54 1 2 0 61596 33716 28748 3433520 0 0 24 415 2087 1890 44 4 49 2 3 0 61592 45300 28904 3416200 3 0 61 403 2282 2154 41 4 54 1 7 0 61592 30172 29092 3416964 0 0 19 358 2779 3478 31 6 63 1 1 0 61580 62948 29180 3417368 6 0 27 312 3632 4396 38 4 57 1 1 0 61444 62388 29400 3417964 0 0 6 354 2163 1918 31 4 64 1 2 0 61444 53988 29648 3417988 0 0 0 553 2095 1687 33 3 63 1 1 0 61444 63988 29832 3418348 0 0 6 352 1767 1424 22 3 73 1 1 1 61444 51148 30052 3419148 0 0 50 349 1524 834 22 3 74 2 1 0 61432 53460 30524 3419572 7 0 7 868 4434 6706 43 6 49 2 1 0 61432 58668 30628 3420148 0 0 0 284 1785 1628 27 3 69 1 iostat sda8 is the where the pg_data resides, sda3 is /var/log avg-cpu: %user %nice %sys %iowait %idle 17.36 0.00 1.96 0.82 79.86 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda3 2.38 0.49 18.71 432395 16672800 sda8 62.34 74.46 491.74 66345555 438143794 avg-cpu: %user %nice %sys %iowait %idle 30.50 0.00 3.57 1.70 64.22 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda3 5.60 0.00 44.80 0 448 sda8 120.20 134.40 956.00 1344 9560 avg-cpu: %user %nice %sys %iowait %idle 20.68 0.00 3.43 1.35 74.54 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda3 3.30 0.00 26.40 0 264 sda8 97.90 0.00 783.20 0 7832 avg-cpu: %user %nice %sys %iowait %idle 22.31 0.00 2.75 0.68 74.27 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda3 2.10 0.00 16.78 0 168 sda8 60.34 0.80 481.92 8 4824 avg-cpu: %user %nice %sys %iowait %idle 11.65 0.00 1.60 1.03 85.72 Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda3 1.70 0.00 13.61 0 136 sda8 59.36 0.00 474.87 0 4744
В списке pgsql-performance по дате отправления: