Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id CD6699F952C for ; Thu, 6 Sep 2007 11:19:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 52068-08 for ; Thu, 6 Sep 2007 11:19:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id 71E3D9F94CD for ; Thu, 6 Sep 2007 11:19:39 -0300 (ADT) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) id 1ITICb-0007l8-4R; Thu, 06 Sep 2007 16:19:25 +0200 Received: from fweimer by bfk.de with local id 1ITICF-0007br-4X; Thu, 06 Sep 2007 16:19:03 +0200 To: Willo van der Merwe 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> From: Florian Weimer Date: Thu, 06 Sep 2007 16:19:03 +0200 In-Reply-To: <46DFE674.6060702@mirasol.co.za> (Willo van der Merwe's message of "Thu, 06 Sep 2007 13:37:24 +0200") Message-ID: <82k5r3op0o.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/79 X-Sequence-Number: 26624 * Willo van der Merwe: > Good advice. After running a vmstat and iostat, it is clear, to my > mind anyway, that the most likely bottleneck is IO, next is probably > some more RAM. > Here's the output: > procs -----------memory---------- ---swap-- -----io---- --system--=20 > ----cpu---- > r b swpd free buff cache si so bi bo in cs us > sy id wa > 0 0 29688 80908 128308 3315792 0 0 8 63 6 8 17 > 2 80 1 You need to run "vmstat 10" (for ten-second averages) and report a couple of lines. > avg-cpu: %user %nice %sys %iowait %idle > 17.18 0.00 1.93 0.81 80.08 Same for iostat. Your initial numbers suggest that your server isn't I/O-bound, though (the percentage spent in iowait is much too small, and so are the tps numbers). --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99