Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 05F322E015F for ; Tue, 4 Mar 2008 05:16:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61285-01 for ; Tue, 4 Mar 2008 05:15:55 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.168]) by postgresql.org (Postfix) with ESMTP id DB6F62E0194 for ; Tue, 4 Mar 2008 05:15:54 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 28so728627wff.28 for ; Tue, 04 Mar 2008 01:15:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=jXigaHqYvqYZQbSkeyaz7YkZW6ZZPEzWU3KgdJCNb3I=; b=TGbHK8/VyyeQBWSPEamP+Vdi6FXv3HK/AXMLSem7oE3LdE2ve2GXTnPGtNL/2qPPTrXl6Z4GTYBSq4R0WRby7gvkhE0SgGODYYVxb846s6AGULEFw89MqiyZ+AAo+UEe8c4OZjwAKSytT7+nS6WNOURAxmZylwIz7h+zbX65bFw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Uu20s1aIXy862NhmblrwXw948uZNIz/7NtAjx3/MZMzWFPK1iCGA5OeKdLUaI8W7Y5draGdlYhwWOo8iLC9lXKzTi0L5iHWz/lcisQ7QiM1mR2RV9LyARFd4j5nVWMdyuotqH/1ts3pYRWx5uGJeHMETXSElvjW0yBC3vSM6yvg= Received: by 10.142.240.9 with SMTP id n9mr502738wfh.6.1204622153922; Tue, 04 Mar 2008 01:15:53 -0800 (PST) Received: by 10.143.38.10 with HTTP; Tue, 4 Mar 2008 01:15:53 -0800 (PST) Message-ID: <892916310803040115q70762bbeibfdcfc536196e099@mail.gmail.com> Date: Tue, 4 Mar 2008 01:15:53 -0800 From: "alan bryan" To: "Greg Smith" Subject: Re: Performance tuning on FreeBSD Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <892916310803031539scffd5bchcce5a848b3a57a32@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/43 X-Sequence-Number: 28997 On Mon, Mar 3, 2008 at 5:11 PM, Greg Smith wrote: > On Mon, 3 Mar 2008, alan bryan wrote: > > >> pgbench -c 100 -t 1000 testdb > > > tps = 558.013714 (excluding connections establishing) > > > > Just for testing, I tried turning off fsync and got: > > > tps = 4061.662041 (excluding connections establishing) > > This is odd. ~500 is what I expect from this test when there is no write > cache to accelerate fsync, while ~4000 is normal for your class of > hardware when you have such a cache. Since you say your 3Ware card is > setup with a cache and a BBU, that's suspicious--you should be able to get > around 4000 with fsync on. Any chance you have the card set to > write-through instead of write-back? That's the only thing that comes to > mind that would cause this. > > -- > * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD > According to 3dm2 the cache is on. I even tried setting The StorSave preference to "Performance" with no real benefit. There seems to be something really wrong with disk performance. Here's the results from bonnie: 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?