From: Neil Saunders <n.j.saunders@gmail.com>
To: Pedro B. <pedro.borracha@netcabo.pt>
Cc: John Mohr <jtmohr@healthconresources.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Why is PGSQL better than MySQL
Date: Tue, 13 Dec 2005 10:13:45 +0000
Message-ID: <ddcd549e0512130213wc600a33x36474da2b6e9fe8d@mail.gmail.com> (raw)
In-Reply-To: <1134440689.25330.112.camel@localhost>
References: <IHEBIKJHMMKHJKLKCDHLMEMMFFAA.jtmohr@healthconresources.com>
<1134440689.25330.112.camel@localhost>
Agreed. You can't argue with a well executed benchmark. All I'd say is
be careful not just the same simple select statement over and over
again - Do a variety of both simple and complex queries. And always
use InnoDB as compared to MyISAM (otherwise you're not comparing
apples with apples). The biggest pro (imho) that PostgreSQL has over
MySQL is its locking mechanism. PostgreSQL uses MVCC, which greatly
improves concurrency.
For a list of "Gotchas" take a look at these:
http://sql-info.de/mysql/gotchas.htmlhttp://sql-info.de/postgresql/postgres-gotchas.html
Also stumbled across this:
http://www.vitavoom.com/postgresql.html
On 12/13/05, Pedro B. <pedro.borracha@netcabo.pt> wrote:
> On Mon, 2005-12-12 at 20:02 -0600, John Mohr wrote:
> > But does anyone know if there is a quasi-categorical comparison of the
> > two so that I could speak with more conviction other than "I know it's
> > better".
>
> I've been involved in that comparison at work, and after some boring
> theoretical discussions, i once turned to my CTO and said:
>
> "Do a test. On the same machine, do a script that executes 50.000
> inserts, OR any other 50.000 SQL operations you want, and benchmark the
> results".
>
> He did, and Postgres immediately got another die-hard fan.
> The facts spoke more clearly than i could ever do, with just words.
> Nowadays, he is even more "defensive" of PGSQL over MySQL than i am.
>
> \\pb
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: n.j.saunders@gmail.com, pedro.borracha@netcabo.pt, jtmohr@healthconresources.com
Subject: Re: Why is PGSQL better than MySQL
In-Reply-To: <ddcd549e0512130213wc600a33x36474da2b6e9fe8d@mail.gmail.com>
References: <IHEBIKJHMMKHJKLKCDHLMEMMFFAA.jtmohr@healthconresources.com> <1134440689.25330.112.camel@localhost> <ddcd549e0512130213wc600a33x36474da2b6e9fe8d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox