Re: Why is PGSQL better than MySQL - Mailing list pgsql-php

From Pedro B.
Subject Re: Why is PGSQL better than MySQL
Date
Msg-id 1134440689.25330.112.camel@localhost
Whole thread Raw
In response to Why is PGSQL better than MySQL  ("John Mohr" <jtmohr@healthconresources.com>)
Responses Re: Why is PGSQL better than MySQL  (Neil Saunders <n.j.saunders@gmail.com>)
Re: Why is PGSQL better than MySQL  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-php
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


pgsql-php by date:

Previous
From: "John Mohr"
Date:
Subject: Why is PGSQL better than MySQL
Next
From: Neil Saunders
Date:
Subject: Re: Why is PGSQL better than MySQL