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

Re: Perpetuating the myth...annoying

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: David Costa <geeks(at)dotgeek(dot)org>
Cc: Jacob Hanson <jacdx(at)jacobhanson(dot)com>,<pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Perpetuating the myth...annoying
Date: 2004-04-05 23:02:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-advocacy
On Mon, 5 Apr 2004, David Costa wrote:

> On Mar 31, 2004, at 4:44 AM, Jacob Hanson wrote:
> >
> >
> > Article discussing PHP5 says SQLite is "typically faster than MySQL,
> > significantly faster than PostgreSQL". While I don't doubt it's
> > faster at what it does (with it's small, focused feature-set), the
> > article perpuates the 'Postgres is slow' and 'MySQL is much faster
> > than Postgres' thinking that is no longer accurate.
> >
> Hi Jacob,
> I have been using SQlite in fact we offer it on dotgeek together with 
> postgresql in the free
> package for developers. The significantly faster is irrelevant because 
> SQLite has a single point of access / failure
> which make it interesting only for small applications.
> Just an idea, why don't we run a postgresql vs mysql benchmark ? I can 
> put the servers, but I have little experience
> on running a benchmark. If someone is willing to help I will grant him 
> access and we can end up with some clean results
> and a nice article on dotgeek with something effective like "PostgreSQL 
> is faster then MySQL: Here's why"
> I think it will spice it all up. Till now we have around 300 PHP 
> developers that started to use PostgreSQL on dotgeek and
> porting their application from mysql to postgresql. Looks promising ;)

I think that if we are going to benchmark the two, and I'm all for it, we 
should benchmark them running something fairly standard, like the OSDL 
tests.  And MySQL should be using innodb tables for everything, since 
postgresql pretty much always carries the load of running mvcc and write 
ahead logging and transactions for everything it does.

In response to


pgsql-advocacy by date

Next:From: scott.marloweDate: 2004-04-05 23:09:18
Subject: Re: Perpetuating the myth...annoying
Previous:From: Devrim GUNDUZDate: 2004-04-05 21:45:31
Subject: Re: Some news from Turkey

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