Date: Tue, 24 Oct 2006 09:19:02 +0200 From: Alban Hertroys <dalroi@solfertje.student.utwente.nl> To: Bill Moran <wmoran@collaborativefusion.com> Cc: Mike Jakubik <mikej@rogers.com>, stable@freebsd.org Subject: Re: Running large DB's on FreeBSD Message-ID: <C01CAF81-9863-4630-AD46-67F9565B8708@solfertje.student.utwente.nl> In-Reply-To: <20061023190931.73ab17d3.wmoran@collaborativefusion.com> References: <453D49D2.1010705@rogers.com> <20061023190931.73ab17d3.wmoran@collaborativefusion.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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!
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?C01CAF81-9863-4630-AD46-67F9565B8708>