-----Original Message----- From: Dimitri Maziuk <dmaz...@bmrb.wisc.edu> To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] SQLite Date: Wed, 29 Apr 2015 10:12:53 -0500 Mailer: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.6.0
On 2015-04-29 08:58, Matt Ivie wrote: > Any input on the topic is appreciated. http://www.sqlite.org/howtocorrupt.html The size of the database is determined by the number of files and retention periods. IRL the most likely corruption scenario is the disk going bad, so size doesn't matter. Where it does matter is performance: with a large catalog postgres's query optimizer can make a lot of difference. Dimitri ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users Thank you Dimitri, your explanation makes perfect sense and puts me at ease to continue using SQLite with bacula. Matt ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
