Bacula-users

Re: [Bacula-users] Postgres vs SQLite

2013-04-30 19:28:20
Subject: Re: [Bacula-users] Postgres vs SQLite
From: James Harper <james.harper AT bendigoit.com DOT au>
To: Tim Gustafson <tjg AT ucsc DOT edu>, "bacula-users AT lists.sourceforge DOT net" <bacula-users AT lists.sourceforge DOT net>
Date: Tue, 30 Apr 2013 23:24:43 +0000
> Hi,
> 
> I was wondering if there was any information about the performance
> difference between running Bacula with a Postgres database vs an
> SQLite database.  I don't have any other need for a Postgres server,
> so if I can get Bacula to perform as well with SQLite as it does with
> Postgres, then I'd prefer to drop Postgres altogether.
> 

If you are backing up one machine with a small number of files then sqlite 
might be okay, but otherwise you'll probably find it will be a performance 
bottleneck for anything bigger.

I recommend you go with postgresql (or mysql).

James


------------------------------------------------------------------------------
Introducing AppDynamics Lite, a free troubleshooting tool for Java/.NET
Get 100% visibility into your production application - at no cost.
Code-level diagnostics for performance bottlenecks with <2% overhead
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap1
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>