Bacula-users

[Bacula-users] 2.2.8 inserting attributes taking a long time

2008-08-28 17:11:58
Subject: [Bacula-users] 2.2.8 inserting attributes taking a long time
From: Michael Galloway <mgx AT ornl DOT gov>
To: bacula <bacula-users AT lists.sourceforge DOT net>
Date: Thu, 28 Aug 2008 17:11:47 -0400
good day all, i've got a biggish job (1.6TB/13M files) that took a few days to 
run, now its
spent a couple of days working on inserting attributes into the db (postgres 
8.2.5), this 
has caused a lot of jobs to queue up and i'm wondering if there is any way to 
get a feel for
how much time it will take to get this finished. postgres is running but not 
very hard:

top - 17:10:07 up 27 days,  8:49,  1 user,  load average: 3.40, 3.29, 3.32
Tasks: 188 total,   1 running, 187 sleeping,   0 stopped,   0 zombie
Cpu0  :  0.0%us,  0.7%sy,  0.0%ni, 67.2%id, 31.5%wa,  0.3%hi,  0.3%si,  0.0%st
Cpu1  :  0.0%us,  1.0%sy,  0.0%ni, 52.6%id, 45.4%wa,  0.0%hi,  1.0%si,  0.0%st
Cpu2  :  3.3%us,  2.0%sy,  0.0%ni, 78.5%id, 16.2%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu3  :  0.0%us,  0.7%sy,  0.0%ni, 99.3%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   8183128k total,  8051916k used,   131212k free,    94844k buffers
Swap: 16771840k total,      200k used, 16771640k free,  7478184k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND            
                                                             
21484 postgres  16   0  139m  66m  35m S    5  0.8  86:42.38 postgres           
                                                             


been running if full since the 24th:

  1414 Full    birch.2008-08-24_00.05.44 Dir inserting Attributes

getting a bit impatient here :-\

-- michael

here is the bacula info:

Connecting to Director molbio:9101
1000 OK: molbio-dir Version: 2.2.6 (10 November 2007)
Enter a period to cancel a command.


-------------------------------------------------------------------------
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