There is nothing that will totally solve the performance problems you're facing... For now, bacula's code does many small operations, each in it's transaction, and postgresql isn't good at that... Removing indexes may help the insert speed, but don't have too much hopes
Le Thursday 14 June 2007 09:02:40 Berner Martin, vous avez écrit : > 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 ------------------------------------------------------------------------- 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
