In response to "user100" <[EMAIL PROTECTED]>: > > I just made a test between Postgres 7.4 (on a faster hardware) / MySQL 4.1 > (on a slower hardware) - and MySQL seems to be 5 time faster with baclua? Do > you think Postgres 8 is faster than Postgres 7
Yes. If you check various PostgreSQL list archives, you'll see that a LOT of perf improvements have been made. You should be running 8.1.4 if you care about performance. > (or MySQL) in use with bacula > - or is there an easy way to tune Postgres to get close to MySQL speed? Easy is a relative term. There are plenty of docs on perf tuning PostgreSQL. Tuning PG is non-trivial, but definitely a task that can be successfully accomplished. Most PG packages that I've seen are _not_ tuned for performance out of the box and require some tweaking. See http://www.postgresql.org/docs/8.1/interactive/runtime-config.html 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. 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. -- Bill Moran Collaborative Fusion Inc. 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
