On Tue, Jul 1, 2008 at 2:28 PM, Hemant Shah <hjrrs AT yahoo DOT com> wrote:
> 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.
>

Do you have your database properly indexed?

http://www.bacula.org/en/dev-manual/Catalog_Maintenance.html#SECTION002480000000000000000

John

-------------------------------------------------------------------------
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