One other point that I forgot I mentioned - PostgresQL does not have a
decent replication solution. There are a few solutions, including one from
The PostgresQL.com version is not the latest - you need to pay for support
to get that. The other ones were (last I looked) incomplete.
----- Original Message -----
From: "David Griffiths" <dgriffiths@stripped>
To: <david.best@stripped>; "Mark Warner"
Sent: Wednesday, March 03, 2004 10:27 AM
Subject: Re: PgSQL vs MySQL
> As a DBA and someone who has worked both with PostgresQL and MySQL, I
> I can answer this knowingly.
> First, MySQL is significantly faster than PostgresQL and Oracle.
> Second, MySQL is also a simpler database to set up and configure.
> Third, the documentation is better, and there are far more third party
> out there.
> Fourth, MySQL has a more impressive list of customers. Yes, there are some
> large PostgresQL customers (the .org domain system?), but none like Yahoo
> and Slashdot.
> MySQL does not have triggers, stored procedures or views yet. Sub-selects
> should be out in six months.
> After fighting with PostgresQL to try to get it to use indexes, rewriting
> tonnes of queries, and still getting poor performance, I gave up on it. I
> prefer MySQL with InnoDB.
> Some of the gotcha's are valid, and others can be found in any database.
> Forewarned is forearmed.
> ----- Original Message -----
> From: <david.best@stripped>
> To: "Mark Warner" <hammerhed@stripped>;
> Sent: Wednesday, March 03, 2004 6:51 AM
> Subject: Re: PgSQL vs MySQL
> > > What advantages, besides ease of setup, does MySQL hold over
> > > It would seem, to me, that the two are close competitors (both in
> > > quality, and performance).
> > Are you sure about quality? Check out:
> > http://sql-info.de/mysql/gotchas.html
> > You can check out postgresql's on the same site but they are
> less critical. After reviewing this and talking to some other people i'm
> switching over to postgresql. I'm sure there is a place with mysql but I
> don't think i'd trust it for anything critical unless you very confident
> your developers know what they are doing.
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1