Skip site navigation (1) Skip section navigation (2)

Re: Postgres v MySQL 5.0

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
Cc: Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>, "Leif B(dot) Kristensen" <leif(at)solumslekt(dot)org>, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Postgres v MySQL 5.0
Date: 2006-11-10 21:33:11
Message-ID: 1163194391.12372.30.camel@dogma.v10.wvs (view raw or flat)
Thread:
Lists: pgsql-advocacy
On Fri, 2006-11-10 at 14:39 -0500, Brad Nicholson wrote:
> On Thu, 2006-11-09 at 11:42 +0100, Lukas Kahwe Smith wrote:
> > Leif B. Kristensen wrote:
> > 
> > > It's hardly more difficult to start using PostgreSQL than MySQL. The 
> > > installation part is mostly the same. Regarding the query language 
> > > itself, the differences are small enough that it doesn't matter much 
> > > from a learning point of view.
> > 
> > The difference is that PostgreSQL does not bundle as much functionality 
> > as MySQL does. Also the simple fact that you have plenty of choices in 
> > PostgreSQL makes it harder as you grow. This is why developers recommend 
> > other developers to use MySQL. Its not only easy to setup, but it will 
> > do what most of them expect even if they grow bigger. Like replication 
> > is in there by default etc.
> 
> Actually, I think the biggest barrier to winning over this crowd is
> performance out of the box.  MySQL just sort of "works" with the default

If I were to choose between "performance out of the box" and "safety out
of the box" I would choose safety every time.

The fact that MySQL chooses performance instead of safety by default is
purely for marketing reasons, and is irresponsible in my opinion. If all
PostgreSQL cared about was attracting those types of new users, they
could ship with fsync=off. 

It's hard to outdo the MySQL marketing, because marketing influences
every aspect of their product.

Regards,
	Jeff Davis


In response to

pgsql-advocacy by date

Next:From: Joshua D. DrakeDate: 2006-11-10 22:39:59
Subject: Re: Postgres v MySQL 5.0
Previous:From: usleeplessDate: 2006-11-10 21:13:47
Subject: Re: Postgres v MySQL 5.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group