Thanks for the Hint. But I have done this trick alredy. I tryed to tune the Postgre, installed more RAM.. But the impact is still huge. Thus the "helper Indexes" commented out in the make_postgre_tables (file_pathid_idx, file_filenameid_idx, file_jpfid_idx) halps pushing up the Performance?
> -----Ursprungliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Auftrag von Marc > Cousin > Gesendet: Donnerstag, 14. Juni 2007 08:45 > An: [EMAIL PROTECTED] > Cc: bacula-users@lists.sourceforge.net > Betreff: Re: [Bacula-users] migrate catalog from PostgreSQL to MySQL > > > 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 > ------------------------------------------------------------------------- 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
