Here's a start for discussion references (running out of battery power):
2. Postgres is successively losing to MySQL. Is MySQL?s performance already better in some areas?
Plans for the mid-term future[1]:
As an alternative to the one-thread-per-connection model, manage a pool of threads to handle queries.
. MySQL Manual | 1.8.5.3 Transactions and Atomic Operations[2]
1.8.5.3 Transactions and Atomic Operations MySQL Server (version 3.23-max and all versions 4.0 and above) supports transactions with the InnoDB and BDB transactional storage engines. InnoDB provides full ACID compliance...
Features available in MySql 4.0[3]
Comparing leading databases[4] (MySQL perspective)
MySql gotchas[5]
MySql passes the acid test?[6]
Recent thread comparing mysql and postgresql[7]
Articles in Germany about posgresql[8]
1. http://www.mysql.com/doc/en/TODO_sometime.html
2. http://www.mysql.com/doc/en/ANSI_diff_Transactions.html
3. http://www.mysql.com/doc/en/Nutshell_4.0_features.html
4. http://www.mysql.com/information/features.html
5. https://openacs.org/forums/message-view?message_id=145359
6. https://openacs.org/forums/message-view?message_id=20355
7. http://archives.postgresql.org/pgsql-general/2003-03/msg01215.php
http://archives.postgresql.org/pgsql-general/2003-03/msg01267.php
8. http://archives.postgresql.org/pgsql-advocacy/2003-11/msg00214.php