Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7CE199FB443 for ; Thu, 6 Sep 2007 15:48:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 86132-02-5 for ; Thu, 6 Sep 2007 15:48:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ctb-mesg-2-1.saix.net (ctb-mesg-2-1.saix.net [196.25.240.86]) by postgresql.org (Postfix) with ESMTP id 4A0E29FA5ED for ; Thu, 6 Sep 2007 15:45:20 -0300 (ADT) Received: from mirasol.co.za (dsl-240-132-190.telkomadsl.co.za [41.240.132.190]) by ctb-mesg-2-1.saix.net (Postfix) with SMTP id AB9B615FEB for ; Thu, 6 Sep 2007 16:33:00 +0200 (SAST) Received: (qmail 4708 invoked by uid 453); 6 Sep 2007 14:33:00 -0000 X-Virus-Checked: Checked by ClamAV on mirasol.co.za Received: from pc-00052.mirasol.co.za (HELO [172.16.0.52]) (172.16.0.52) by mirasol.co.za (qpsmtpd/0.40) with ESMTP; Thu, 06 Sep 2007 10:33:00 -0400 Message-ID: <46E00F9C.40704@mirasol.co.za> Date: Thu, 06 Sep 2007 16:33:00 +0200 From: Willo van der Merwe User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: Florian Weimer CC: Jean-David Beyer , pgsql-performance@postgresql.org Subject: Re: Hardware spec 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> In-Reply-To: <82k5r3op0o.fsf@mid.bfk.de> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/93 X-Sequence-Number: 26638 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