Jarrod Holder wrote:
> Bacula version 5.0.3
>  
> In BAT, when trying to restore a directory (roughly 31,000 files in 560 sub 
> folders)  The "Filling Database Table" takes an extremely long time to 
> complete (about an hour or so).
>  
> I've been looking around for a way to speed this up.  Found a post on here 
> that referred to an article that basically said PostgreSQL was the way to go 
> as far as speed 
> (http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog).
>   So I converted from MySQL to PostgreSQL using the conversion procedure in 
> the Bacula documentation.  We are now on PostgreSQL, but the speed seems just 
> as slow (if not slower).  Is there anything else that can be done to speed 
> this process up?

Have you performed any mysql/postgresql optimisations?

Default configs for both databases are slow.




------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users