Re: Hardware spec - Mailing list pgsql-performance

From Willo van der Merwe
Subject Re: Hardware spec
Date
Msg-id 46E00F9C.40704@mirasol.co.za
Whole thread Raw
In response to Re: Hardware spec  (Florian Weimer <fweimer@bfk.de>)
List 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 by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: SAN vs Internal Disks
Next
From: Joe Uhl
Date:
Subject: Re: SAN vs Internal Disks