Re: [Bacula-users] Re ducing the size of the database.

2008-10-21 Thread Hemant Shah
--- On Tue, 10/21/08, ebollengier <[EMAIL PROTECTED]> wrote: > From: ebollengier <[EMAIL PROTECTED]> > Subject: Re: [Bacula-users] Re ducing the size of the database. > To: bacula-users@lists.sourceforge.net > Date: Tuesday, October 21, 2008, 2:25 AM > If it'

Re: [Bacula-users] Re ducing the size of the database.

2008-10-21 Thread Hemant Shah
--- On Tue, 10/21/08, John Huttley <[EMAIL PROTECTED]> wrote: > From: John Huttley <[EMAIL PROTECTED]> > Subject: Re: [Bacula-users] Re ducing the size of the database. > To: "ebollengier" <[EMAIL PROTECTED]> > Cc: bacula-users@lists.sourceforge.net &g

Re: [Bacula-users] Re ducing the size of the database.

2008-10-21 Thread John Huttley
Run 'vacuum full' but this will lock the database as it needs exclusive use of the tables. After that, perform a reindex. --John ebollengier wrote: If it's 40,000 rows of the filename or path table, each rows are something like 10 or 15 bytes long If you want to reduce the size of your

Re: [Bacula-users] Re ducing the size of the database.

2008-10-21 Thread ebollengier
If it's 40,000 rows of the filename or path table, each rows are something like 10 or 15 bytes long If you want to reduce the size of your database, you need to review your retention periode or to prune jobs (ie, remove backup content information from the catalog). See the manual for more in