Date: Wed, 25 Oct 2006 16:26:45 -0400 From: "Bucky Jordan" <bjordan@lumeta.com> To: "Kirk Strauser" <kirk@strauser.com>, <freebsd-stable@freebsd.org> Subject: RE: Running large DB's on FreeBSD Message-ID: <78ED28FACE63744386D68D8A9D1CF5D4209DCD@MAIL.corp.lumeta.com> In-Reply-To: <200610251259.57388.kirk@strauser.com>
next in thread | previous in thread | raw e-mail | index | archive | help
You may find this article interesting: http://tweakers.net/reviews/638/4 The whole MySQL vs. PostgreSQL discussion can be very lively and interesting, however I sort of doubt the bsd-stable list is the place. You might want to ask specific questions on the relevant MySQL and PostgreSQL discussion lists to assist you with your decision.=20 I've been a long time user of Postgres, and having to use MySQL on a recent project just reaffirmed that preference, but that's just my 2 cents. - Bucky > -----Original Message----- > From: owner-freebsd-stable@freebsd.org [mailto:owner-freebsd- > stable@freebsd.org] On Behalf Of Kirk Strauser > Sent: Wednesday, October 25, 2006 2:00 PM > To: freebsd-stable@freebsd.org > Subject: Re: Running large DB's on FreeBSD >=20 > On Monday 23 October 2006 6:01 pm, Mike Jakubik wrote: >=20 > > I'm not exactly informed as to the specific workload yet, however i know > > the database will have several million rows and be larger than 10GB. >=20 > No offense, but that's a pretty small database. Also, IMHO the crazy part > is using MySQL over PostgreSQL. It's hardly any faster, and you have to > do > a *lot* of client-side work to emulate PostgreSQL's built-in functions. > Unless you use the much slower InnoDB that's now owned by Oracle, in which > case MySQL gets most of those features (but is no faster than PostgreSQL > would be). > -- > Kirk Strauser
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?78ED28FACE63744386D68D8A9D1CF5D4209DCD>