From owner-freebsd-performance@FreeBSD.ORG Mon Feb 26 22:40:45 2007 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 90F6216A402 for ; Mon, 26 Feb 2007 22:40:45 +0000 (UTC) (envelope-from paul@pathiakis.com) Received: from mail2.eagleinvsys.com (mail2.eagleinvsys.com [151.203.101.53]) by mx1.freebsd.org (Postfix) with ESMTP id 44DF313C494 for ; Mon, 26 Feb 2007 22:40:45 +0000 (UTC) (envelope-from paul@pathiakis.com) Received: from [10.40.1.102] ([10.40.1.102]) by mail2.eagleinvsys.com with Microsoft SMTPSVC(5.0.2195.6713); Mon, 26 Feb 2007 17:18:08 -0500 From: Paul Pathiakis Organization: Atlantis Services To: freebsd-performance@freebsd.org Date: Mon, 26 Feb 2007 17:17:33 -0500 User-Agent: KMail/1.9.5 References: <20070224215508.GA41968@xor.obsecurity.org> <5a0a9d6f0702260936u3408f8d8rd4cde9234b2f7776@mail.gmail.com> <046f01c759dc$d60a60b0$b3db87d4@multiplay.co.uk> In-Reply-To: <046f01c759dc$d60a60b0$b3db87d4@multiplay.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200702261717.33325.paul@pathiakis.com> X-OriginalArrivalTime: 26 Feb 2007 22:18:08.0079 (UTC) FILETIME=[FE3E9DF0:01C759F3] Subject: Re: Progress on scaling of FreeBSD on 8 CPU systems X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 26 Feb 2007 22:40:45 -0000 > > What makes PostgreSQL more interesting? Because you use it perhaps? > I would hesitate a guess that Mysql is a very common workload > under FreeBSD likely more so than PostgreSQL and as such that > would be a very good reason for it to have particular interest > and hence focus as a good starting point. > > Steve > I'm not trying to start a flame war, I'm just trying to give my take on "perception" here. PostgreSQL is developed on FreeBSD and they've always had a close relationship by means of FreeBSD being the "platform of choice". PostgreSQL is considered a "real" database. When you look at commercial databases, there tend to be two large market shares: Oracle and DB2. Oracle has moved into the realm of clustered access database with multiple path writing into the DB and it can scale to be quite large. PostgreSQL has a large installed base. SUN Microsystems is now supporting it. It's free. It has advanced features like clustering. It scales to be quite large. MySQL has been the "white elephant in the middle of the room" for a while and then it became the thing for the Linux community to point at to "prove" inferiority. MySQL is on the order of the small to medium db. Easy to configure, easy to tune. Similar to MS SQL, it's widely used and scales to a certain level (so far, however, this new benchmarking may show it's not MySQL that's the issue.) Please don't jump on this mail, it's just a "perception" letter. There's no facts in it and I freely admit that. It's a "touchy/feely" thing in the OSS community. I've helped a few companies replace heavy read Oracle DBs with PostgreSQL. They love not paying money to Larry & Co. P.