As a DBA and someone who has worked both with PostgresQL and MySQL, I think 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 books 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. David. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Mark Warner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, March 03, 2004 6:51 AM Subject: Re: PgSQL vs MySQL > > > What advantages, besides ease of setup, does MySQL hold over PostgreSQL? > > 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 significally 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: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
