Hi!

On Fri, Aug 29, 2008 at 4:41 PM, Michael Galloway <mgx AT ornl DOT gov> wrote:
> 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:
>

That is a DB issue, did you correctly tuned pgsql's parameters? I
mean, you got plenety of ram, you must tell postgres to use it! (and
to use cache).

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

I hope this helps,

Ildefonso Camargo

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