Re: Why is PGSQL better than MySQL

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