I have the following indexes defined in my postgersql db.
bacula=> \di+ (file_|job_)*
Schema | Name | Type | Owner | Description | Table
+---+---++-+--
public | file_fp_idx | index
On Sat, Jan 28, 2006 at 09:48:11AM -0600, Jeffrey L. Taylor wrote:
> I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and
> Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I
> killed the orphaned path check after 2 days.
Out of curiosity, how many rows do you have i
On 28 Jan 2006 at 12:54, Drew Tomlinson wrote:
> On 1/28/2006 7:48 AM Jeffrey L. Taylor wrote:
>
> >I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and
> >Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I
> >killed the orphaned path check after 2 days.
> >
> >
>
On 1/28/2006 7:48 AM Jeffrey L. Taylor wrote:
I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and
Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I
killed the orphaned path check after 2 days.
This made an amazing difference for me as well. I know basically
I added 4 indexes: File.PathId, File.FilenameId, Job.FileSetId, and
Job.ClientId. dbcheck now takes 1 minute. Without the indexes, I
killed the orphaned path check after 2 days.
HTH,
Jeffrey
Quoting Deann Corum <[EMAIL PROTECTED]>:
> Thanks Jeffrey and Attiila. I'll look at the dbcheck script
Thanks Jeffrey and Attiila. I'll look at the dbcheck script and see what
I can figure out. And the mysqladmin processlist command is very
helpful. It's also good to know others out there have large Bacula
databases. I still wonder what the largest known one is!
It seems we're ok even though w
Quoting deann corum <[EMAIL PROTECTED]>:
> Hello,
>
> I'm wondering what the largest known Bacula database in existence is.
> This is mostly a curiosity point. The actual problem follows.
>
> Our Bacula db is 13 GB and we recently tried to run (Bacula's) dbcheck
> on it. However, it ran for 2+
Well I run bacula 1.38.5 with postgresql 7.4 on a dual opteron 248
(2.2GHz) on FreeBSD 5.4 and dbcheck on a 2GB database needs 1-2
minutes to complete. 1.36 performed equally well, whereas with
SQLite it didn't finish within a week.
deann corum wrote:
Hello,
I'm wondering what the largest know
Hi,
On 1/27/2006 6:15 PM, deann corum wrote:
Hello,
I'm wondering what the largest known Bacula database in existence is.
This is mostly a curiosity point. The actual problem follows.
My catalog DB is much smaller, but it's running on a slow machine.
dbcheck needs hours, not days.
Our Bac
Hello,
I'm wondering what the largest known Bacula database in existence is.
This is mostly a curiosity point. The actual problem follows.
Our Bacula db is 13 GB and we recently tried to run (Bacula's) dbcheck
on it. However, it ran for 2+ days and meanwhile, our backups weren't
running mean
10 matches
Mail list logo
