Running large DB's on FreeBSD

[Bucky Jordan]

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. 

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 at freebsd.org [mailto:owner-freebsd-
> stable at freebsd.org] On Behalf Of Kirk Strauser
> Sent: Wednesday, October 25, 2006 2:00 PM
> To: freebsd-stable at freebsd.org
> Subject: Re: Running large DB's on FreeBSD
> 
> On Monday 23 October 2006 6:01 pm, Mike Jakubik wrote:
> 
> > 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.
> 
> 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