On Thursday 14 June 2007 08:36:19 Berner Martin wrote: > Yes it is because I have some bottleneck with PostgreSQL as backend. So I > try to give MySQL a try on a Testenvirement. But it has no sense if I cant > migrate the catalogue. And to make a true comparison it is important to > have as much entries in both Databases. Before migrating I made some Tests > with a empty Mysql-DB. I back up a Directory with 10000 textfiles each > contains only its name. Postgres 1.5 Minutes, Mysql 20-40 seconds. Compared > with the tared directory (one File with same size as all together both > Databases take about 2 seconds. You talk about Performance with Postgres. > What can I do to push up the performance with Postgres till next release > will bring me the "batch insert"?
For now, you can turn fsync to off in postgresql.conf. Be aware that you may corrupt the database in case of a system crash. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
