pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: Willo van der Merwe <willo@mirasol.co.za>
To: Florian Weimer <fweimer@bfk.de>
Cc: Jean-David Beyer <jeandavid8@verizon.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware spec
Date: Thu, 06 Sep 2007 16:33:00 +0200
Message-ID: <46E00F9C.40704@mirasol.co.za> (raw )
In-Reply-To: <82k5r3op0o.fsf@mid.bfk.de >
References: <46DFA43C.2030201@mirasol.co.za >
<46DFB79E.9040407@archonet.com >
<46DFC7D6.2080803@mirasol.co.za >
<46DFE170.20206@verizon.net >
<46DFE674.6060702@mirasol.co.za >
<82k5r3op0o.fsf@mid.bfk.de >
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
view thread (12+ messages) latest in thread
Message-ID: <46E00F9C.40704@mirasol.co.za>
Permalink: ../46E00F9C.40704@mirasol.co.za/
Also on: postgresql.org/message-id/46E00F9C.40704@mirasol.co.za
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: willo@mirasol.co.za, fweimer@bfk.de, jeandavid8@verizon.net
Subject: Re: Hardware spec
In-Reply-To: <46E00F9C.40704@mirasol.co.za>
* 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