I recently took a system from MySQL to Postgres. Same HW, SW, same data. The major operations where moderately complex queries (joins on 8 tables).
The results we got was that Postgres was fully 3 times slower than MySql. We were on this list a fair bit looking for answers and tried all the standard answers. It was still much much much slower. Brian Tarbox -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rafal Kedziorski Sent: Friday, July 04, 2003 6:03 AM To: [EMAIL PROTECTED] Subject: [PERFORM] PostgreSQL vs. MySQL Hi, has anybody tested PostgreSQL 7.3.x tables agains MySQL 4.0.12/13 with InnoDB? Regards, Rafal ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match