Re: [Bacula-users] slow postgres, index/table does not exist

2007-01-30 Thread Geoff Tolley
Bill Moran wrote: > In response to Bacula User <[EMAIL PROTECTED]>: >> My untuned postgres is too slow. I'm researching ways to speed it up. If >> you have pointers, please share. > > Can you replace 7.4 with 8.2? There are a LOT of performance improvements > in 8.2 over 7.4. I'll second that

Re: [Bacula-users] slow postgres, index/table does not exist

2007-01-30 Thread Bill Moran
In response to Bacula User <[EMAIL PROTECTED]>: > > I am using freebsd 6.1, bacula 1.38.11_1, and postgresql-server-7.4.13_1. > Each night I dump 913,157,728,765 bytes of 5,395,281 files to tape. I > spool data and attributes. I will need to almost triple this amount to > deploy bacula. Data go

[Bacula-users] slow postgres, index/table does not exist

2007-01-30 Thread Bacula User
Hi list, I am using freebsd 6.1, bacula 1.38.11_1, and postgresql-server-7.4.13_1. Each night I dump 913,157,728,765 bytes of 5,395,281 files to tape. I spool data and attributes. I will need to almost triple this amount to deploy bacula. Data goes to tape in under 16.5 hours, but attributes co