From owner-freebsd-database@FreeBSD.ORG Tue Aug 26 06:20:04 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E251F16A4BF; Tue, 26 Aug 2003 06:20:04 -0700 (PDT) Received: from abe.micropat.com (abe.micropat.com [204.17.221.119]) by mx1.FreeBSD.org (Postfix) with ESMTP id ADE2143FE1; Tue, 26 Aug 2003 06:20:03 -0700 (PDT) (envelope-from paul@pathiakis.com) Received: from 10.0.0.101 ([204.17.221.104]) by abe.micropat.com (Netscape Messaging Server 4.15) with ESMTP id HK8A1O00.6UF; Tue, 26 Aug 2003 09:13:00 -0400 From: Paul Pathiakis To: Michael Nottebrock Date: Tue, 26 Aug 2003 09:19:28 -0400 User-Agent: KMail/1.5.3 References: <200308250929.32143.paul@pathiakis.com> <3F4B55A1.6000601@gmx.net> In-Reply-To: <3F4B55A1.6000601@gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200308260919.28371.paul@pathiakis.com> cc: freebsd-database@freebsd.org cc: freebsd-performance@freebsd.org Subject: Re: Tuning Postgresql on FreeBSD 5.1 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: paul@pathiakis.com List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 26 Aug 2003 13:20:05 -0000 Ummm....seriously? Well, after you get all the marginal parameters on the compilation and everything else cleared away, you have the "platform of choice". This is what development takes place on "in-house" so to speak. The developers become a lot more familiar through symbiosis with OS developers and sysadmins. They get to know a lot more about how to tune and performance enhance the machines on that platform. Usually, (not an absolute, only a fool speaks in absolutes) there's just a lot more understood about the OS and tuning is at a higher level and performance is better overall. (We can split hairs on this philosophy all day, however, this is just my opinion and response to your query. I REALLY DON'T want to start a thread on this.) Also, thanks to everyone whose responded so far! I will check on the starvation aspect, however, I did notice while using systat -vm that there was no starvation on memory or anything else. That's why I was concerned as to why the machine halted/stalled. I'm turning off HTT now and will see how it performs. P. On Tuesday 26 August 2003 08:42 am, Michael Nottebrock wrote: > Paul Pathiakis wrote: > > It is my belief that a BSD DB is > > going to run faster on it's platform of choice for development (FreeBSD) > > than another OS. > > Why? I mean, seriously, what has the platform you run your gcc and vim on > to do with performance at the end of the day?