Progress on scaling of FreeBSD on 8 CPU systems
Paul Pathiakis
paul at pathiakis.com
Mon Feb 26 22:40:45 UTC 2007
>
> 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.
More information about the freebsd-performance
mailing list