We were doing a simple test with MySQL 5.5 and PostgreSQL 9.0.4. The test is so simple. we are inserting to table in a loop. we have simple table with one field
integer autoincrement primary key and some text fields.
The client program is written in JAVA for PostgreSQL. The client program is written in PHP(running from command line) for MySQL.
PostgreSQL is running under Windows XP Service pack 3. MySQL is running under Fedora 15. MySQL is also using InnoDB as storage engine.
All of the configuration left as default. no changes(Installation Configuration)
PostgreSQL is doing about 1063 INSERT Transactions Per Second. MySQL is doing about 30 INSERT Transactions Per Second.
I think there must be a problem. Is there any or it is normal?