On 7 Aug 2007 at 11:57, Tod Hagan wrote: > On Thu, 2007-08-02 at 20:31 -0400, John Drescher wrote: > > > Below I've included some output from tapeinfo as the scsi tape driver is > > > the most likely source of the slowdown. I've tried 'mt -f /dev/nst0 > > > stsetoptions buffer-writes async-writes' with no effect. > > > > > > I'd really appreciate some ideas on increasing the backup speeds to the > > > levels we used to get. > > > > > I doubt that the tape drive is the cause. Did you make any database changes? > > Sort of. A more recent postgresql package was installed from scratch, > and the database restored via 'psql bacula < bacula.sql'. > > Does the above method of restoring a postgresql database create indexes?
It will recreate any indexes that were present in the original database. Running "vacuum analyse" from within psql will help refresh the table statistics which are used during query planning. -- Dan Langille - http://www.langille.org/ Available for hire: http://www.freebsddiary.org/dan_langille.php ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
