One other point that I forgot I mentioned - PostgresQL does not have a decent replication solution. There are a few solutions, including one from PostgreSQL.com.
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. Davi. ----- Original Message ----- From: "David Griffiths" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Mark Warner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]