Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id CFD889FA248 for ; Tue, 12 Dec 2006 11:26:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 78148-09 for ; Tue, 12 Dec 2006 11:26:12 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx00.pub.collaborativefusion.com (mx00.pub.collaborativefusion.com [206.210.89.199]) by postgresql.org (Postfix) with ESMTP id DAA309F9357 for ; Tue, 12 Dec 2006 11:26:12 -0400 (AST) Received: from vanquish.pgh.priv.collaborativefusion.com (vanquish.pgh.priv.collaborativefusion.com [192.168.2.61]) (SSL: TLSv1/SSLv3,256bits,AES256-SHA) by wingspan with esmtp; Tue, 12 Dec 2006 10:26:11 -0500 id 00056407.457ECA13.00005957 Date: Tue, 12 Dec 2006 10:26:10 -0500 From: Bill Moran To: Ron Cc: Greg Smith , pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations Message-Id: <20061212102610.7767aa7c.wmoran@collaborativefusion.com> In-Reply-To: References: <87u002mv49.fsf@wolfe.cbbrowne.com> <8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com> <60psaq5t94.fsf@dba2.int.libertyrms.com> <20061211173105.GH16692@mathom.us> <20061211184726.GI16692@mathom.us> <457DA782.3060506@modgraph-usa.com> <8a0c7af10612111422x6bdcc0c2p7cbfeb5a7b0e0374@mail.gmail.com> <20061212013706.GM16692@mathom.us> Organization: Collaborative Fusion X-Mailer: Sylpheed version 2.2.9 (GTK+ 2.10.6; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/294 X-Sequence-Number: 22350 In response to Ron : > > 3= Daniel van Ham Colchete is running Gentoo. That means every SW > component on his box has been compiled to be optimized for the HW it > is running on. > There may be a combination of effects going on for him that others > not running a system optimized from the ground up for its HW do not see. http://www.potentialtech.com/wmoran/source.php You get an idea of how old these tests are by the fact that the latest and greatest was FreeBSD 4.9 at the time, but I suppose it may still be relevent. -- Bill Moran Collaborative Fusion Inc.