Folks,

  I do a full backup on 1st friday of the month and incremental on other days. 
Everything is backed up to disk.

  I tried to run restore from bat. After selecting the directories to restore 
(all the jobs from the last full backup to the last incremental backup were 
selected), when I clicked on "Restore" button, it spent over 2 hours processing 
selected directories and filling database tables. Once it was done doing that, 
I selected alternate directory for restoring the files, the files were restored 
in less than 5 minutes.

  During this time postmaster (postgresql) process was using up all CPU time 
and there was lots of disk I/O.

  Why is it taking so long to process the list? I am using postgresql. I ran 
vacuum full and analyze commands and ran restore again, but still no 
difference. 

Hemant Shah
E-mail: hjrrs AT yahoo DOT com


      

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users