X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AAE22329D3B for ; Tue, 14 Sep 2004 22:45:44 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48377-07 for ; Tue, 14 Sep 2004 21:45:41 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [66.143.173.58]) by svr1.postgresql.org (Postfix) with ESMTP id 0BBC9329D2A for ; Tue, 14 Sep 2004 22:45:41 +0100 (BST) Received: by flake.decibel.org (Postfix, from userid 1001) id F10E61C8B6; Tue, 14 Sep 2004 16:45:40 -0500 (CDT) Date: Tue, 14 Sep 2004 16:45:40 -0500 From: "Jim C. Nasby" To: "Jeffrey W. Baker" Cc: Vivek Khera , pgsql-general@postgresql.org Subject: Re: disk performance benchmarks Message-ID: <20040914214540.GJ56059@decibel.org> References: <1095185498.5792.12.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1095185498.5792.12.camel@localhost.localdomain> X-Operating-System: FreeBSD 4.10-RELEASE-p2 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/656 X-Sequence-Number: 65862 On Tue, Sep 14, 2004 at 11:11:38AM -0700, Jeffrey W. Baker wrote: > procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- > r b swpd free buff cache si so bi bo in cs us sy id wa > 3 0 216 13852 39656 7739724 0 0 820 2664 2868 2557 16 2 74 7 > 0 0 216 17580 39656 7736460 0 0 3024 4700 3458 4313 42 6 52 0 > 0 0 216 16428 39676 7737324 0 0 840 4248 3930 4516 0 4 89 8 > 0 1 216 18620 39672 7736920 0 0 7576 516 2738 3347 1 4 55 39 > 0 0 216 14972 39672 7738960 0 0 1992 2532 2509 2288 2 3 93 3 > 0 0 216 13564 39672 7740592 0 0 1640 2656 2581 2066 1 3 97 0 > 0 0 216 12028 39672 7742292 0 0 1688 3576 2072 1626 1 2 96 0 > 0 0 216 18364 39680 7736164 0 0 1804 3372 1836 1379 1 4 96 0 > 0 0 216 16828 39684 7737588 0 0 1432 2756 2256 1720 1 3 94 2 > 0 0 216 15452 39684 7738812 0 0 1188 2184 2384 1830 1 2 97 0 > 0 1 216 15388 39684 7740104 0 0 1336 2628 2490 1974 2 3 94 2 > 6 0 216 15424 39684 7740240 0 0 104 3472 2757 1940 3 2 92 2 > 0 0 216 14784 39700 7741856 0 0 1668 3320 2718 2332 0 3 97 0 > > You can see there's not much progress being made there. In the Those IO numbers look pretty high for nothing going on. Are you sure you're not IO bound? -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"