-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jeff Dickens wrote:
> For what it's worth I've created these two sql files that I use before 
> and after every dbcheck:
> 
> ::::::::::::::
> extra_indexes.sql
> ::::::::::::::
> create index File_PathId_idx on File(PathId);
> create index File_FilenameId_idx on File(FilenameId);
> ::::::::::::::
> remove_extra_indexes.sql
> ::::::::::::::
> drop index File_FilenameId_idx on File;
> drop index File_PathId_idx on File;
> 
> 
> The create index commands take a while to work, but then the dbcheck 
> goes much more quickly.  My catalog is about 500MB.  I was told if I 
> didn't remove the extra indexes it would slow down insert operations.
> 
> Without these, the dbcheck will apparently never finish, with a dual 
> xeon 3.2 Ghz and 10kRPM u320 disks...
> 
> If I've said this before pardon me for repeating myself, but this should 
> be a explicitly addressed in the docs/FAQs.

That is an interesting thought. On my system, a 3 UltraSparc II 296MHz
processor machine with 896MB of RAM (yeah, some weird numbers, eh?), one
of the added indexes took 1 hour to generate. I wonder if the
performance hit on an insert is enough to want to do that every time I
run dbcheck. I suspect that it may not be, but then again, I also have
only ever run dbcheck once (after this thread solved my problem), and I
run backups every day.

I'd love to hear some comments on performance. I suppose I can do my own
somewhat arbitrary test tonight as one of the larger backups will run
for the first time with the index added. It will also run for the first
time with TLS, though, and I'm not sure if that will also impact speed.

- --
 ---- _  _ _  _ ___  _  _  _
 |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
 |$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
 \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIqzowmb+gadEcsb4RAr21AKCohnLiHfhEjJOf1N5OTRWqIfdy4QCgtT0u
dXM3/mCICXnoLCJTxU+OzsQ=
=Klu5
-----END PGP SIGNATURE-----

novosirj.vcf
Description: Vcard

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users