> Additionally, MySQL with MyISAM will _always_ be faster than > PG, because MyISAM doesn't support transactions. The > overhead of ensuring your data is ACID slows things down a > bit. If you want to try to compare MySQL to PostgreSQL, use > InnoDB or BDB tables.
You'd really want InnoDB if you're going to do any kind of fair comparison. BDB doesn't do any "kind of MVCC", whereas InnoDB does. > Also, ensure that you vacuum and analyze PostgreSQL databases > frequently. > An occasional REINDEX helps as well. These are normal > maintenance tasks for PostgreSQL. ANALYZE is especially > important right after populating a new database. REINDEX really shouldn't be needed anymore as long as your database is properly configured, but if you're still on 7.x it may be. //Magnus ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
