From owner-freebsd-stable@FreeBSD.ORG Tue Oct 24 07:19:15 2006 Return-Path: X-Original-To: stable@freebsd.org Delivered-To: freebsd-stable@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8F97116A407 for ; Tue, 24 Oct 2006 07:19:15 +0000 (UTC) (envelope-from dalroi@solfertje.student.utwente.nl) Received: from solfertje.student.utwente.nl (solfertje.student.utwente.nl [130.89.167.40]) by mx1.FreeBSD.org (Postfix) with ESMTP id 350ED43D5D for ; Tue, 24 Oct 2006 07:19:09 +0000 (GMT) (envelope-from dalroi@solfertje.student.utwente.nl) Received: from localhost (localhost.internal [127.0.0.1]) by solfertje.student.utwente.nl (Postfix) with SMTP id 75C828057 for ; Tue, 24 Oct 2006 09:18:19 +0200 (CEST) Received: from [10.236.150.4] (hollewijn.internal [10.236.150.4]) by solfertje.student.utwente.nl (Postfix) with ESMTP id 5481F8020; Tue, 24 Oct 2006 09:18:15 +0200 (CEST) In-Reply-To: <20061023190931.73ab17d3.wmoran@collaborativefusion.com> References: <453D49D2.1010705@rogers.com> <20061023190931.73ab17d3.wmoran@collaborativefusion.com> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: Alban Hertroys Date: Tue, 24 Oct 2006 09:19:02 +0200 To: Bill Moran X-Mailer: Apple Mail (2.752.2) X-DSPAM-Result: Innocent X-DSPAM-Processed: Tue Oct 24 09:18:19 2006 X-DSPAM-Confidence: 1.0000 X-DSPAM-Probability: 0.0023 X-DSPAM-Signature: 363,453dbe3b7241041496339 X-DSPAM-Factors: 27, helpful, 0.40000, but, 0.40000, but, 0.40000, and+helpful, 0.40000, From*Alban, 0.40000, just, 0.40000, just, 0.40000, (I've+seen, 0.40000, load)+I've, 0.40000, the+mailing, 0.40000, from+a, 0.40000, Mime-Version*Message, 0.40000, you+really, 0.40000, usually+fail, 0.40000, around+at, 0.40000, Is+it, 0.40000, fail+to, 0.40000, or, 0.40000, or, 0.40000, Received*Tue, 0.40000, legged, 0.40000, lot+of, 0.40000, Received*24+Oct, 0.40000, from, 0.40000, Moran+wrote, 0.40000, optimized+for, 0.40000, of, 0.40000 Cc: Mike Jakubik , stable@freebsd.org Subject: Re: Running large DB's on FreeBSD X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 24 Oct 2006 07:19:15 -0000 On Oct 24, 2006, at 1:09, Bill Moran wrote: > Well, you should be using FreeBSD+PostgreSQL, but that's just my > religion. Is it religion when it just makes more sense? But I digress. There are numerous reasons to prefer PostgreSQL over MySQL, a few of which are: - It scales well to multiple CPUs (almost linear, provided your connections are under sufficient load). I've seen benchmarks like this from a 16 CPU Altix (SGI). - It can do complex queries, and it does them well (I've seen it outperform MySQL regularly - especially where MySQL couldn't perform the query directly). - Data integrity is very important to the PostgreSQL community, so it doesn't ignore errors or truncate your data or things like that (MySQL does). - It has a great community; the people on the mailing lists are very knowledgeable and helpful. You'll usually have a solution for a problem within a day. - AFAIK, the key developers run FreeBSD. One thing; there are a lot of PostgreSQL vs. MySQL comparisons, but they usually fail to tune both databases properly or test with workloads that have been optimized for MySQL. For further questions you really should ask around at the postgresql mailing lists. Regards, -- Alban Hertroys "It's not a bug! It's a six-legged feature!" !DSPAM:363,453dbe3b7241041496339!