there is a way to 'cheat' : either use fsync = off in postgresql (that sucks), or try a writeback enabled raid controller. In both cases you're taking a risk, but it's rather low in the second one. These two cheats both remove the sync wait created by the transactions on the 'WAL' (journal) files on postgresql.
On Wednesday 05 July 2006 16:10, Bill Moran wrote: > 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. 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
