Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 598C12E0174 for ; Tue, 4 Mar 2008 06:22:49 -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 95178-09 for ; Tue, 4 Mar 2008 06:22:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 5E31A2E0171 for ; Tue, 4 Mar 2008 06:22:46 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m24AMi5T027450; Tue, 4 Mar 2008 05:22:44 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m24AMhAv027445; Tue, 4 Mar 2008 05:22:43 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 4 Mar 2008 05:22:43 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com To: alan bryan cc: pgsql-performance@postgresql.org Subject: Re: Performance tuning on FreeBSD In-Reply-To: <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com> Message-ID: References: <892916310803031539scffd5bchcce5a848b3a57a32@mail.gmail.com> <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/44 X-Sequence-Number: 28998 On Tue, 4 Mar 2008, alan bryan wrote: > There seems to be something really wrong with disk performance. Here's > the results from bonnie So input speed is reasonable but write throughput is miserable--<10MB/s. I'd suggest taking this to one of the FreeBSD lists; this doesn't look like a PostgreSQL problem. > 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? The other thing you might consider is booting with a Linux live CD/DVD (something like Ubuntu would work) and running bonnie++ from there to see what you get. Help to sort out whether this ia a server problem or an OS one. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD