On Thursday 14 June 2007 10:53:09 Marc Cousin wrote: > 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 > One thing that I've seen with Postgresql in general is that a "VACUUM ANALYZE" can give a big perfomaceboost on writes/updates. This should be run before backupjobs begin.
-- Svein-Erik Lund ------------------------------------------------------------------------- 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
