Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DC8F92E0322 for ; Tue, 4 Mar 2008 06:50:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 02886-02 for ; Tue, 4 Mar 2008 06:50:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 4587A2E0321 for ; Tue, 4 Mar 2008 06:50:52 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JWUjR-0006wP-Vc for pgsql-performance@postgresql.org; Tue, 04 Mar 2008 10:50:49 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 04 Mar 2008 10:50:49 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 04 Mar 2008 10:50:49 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Ivan Voras Subject: Re: Performance tuning on FreeBSD Date: Tue, 04 Mar 2008 11:54:25 +0100 Lines: 24 Message-ID: References: <892916310803031539scffd5bchcce5a848b3a57a32@mail.gmail.com> <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.6 (X11/20071022) In-Reply-To: <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=AWL=0.000 X-Spam-Level: X-Archive-Number: 200803/46 X-Sequence-Number: 29000 alan bryan wrote: > File './Bonnie.2551', size: 104857600 > Writing with putc()...done > Rewriting...done > Writing intelligently...done > Reading with getc()...done > Reading intelligently...done > Seeker 1...Seeker 2...Seeker 3...start 'em...done...done...done... > -------Sequential Output-------- ---Sequential Input-- --Random-- > -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- > Machine MB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU > 100 9989 4.8 6739 1.0 18900 7.8 225973 98.5 1914662 > 99.9 177210.7 259.7 > > This is on FreeBSD 7.0-Release. I tried ULE and 4BSD schedulers with > no difference. Maybe I'll try FreeBSD 6.3 to see what that does? Generally, you should set the "size" parameter to be twice the RAM you've got (or use bonnie++ which will auto-size it), but anyway, something is definitely wrong with your drives, controller or the driver. Switching schedulers won't help you, and trying different releases will only help you if the problem is in the driver. Try asking on the freebsd-performance @ freebsd.org list.