Hi,

23.04.2009 11:45, Ronald Buder wrote:
> Hi List,
> 
> I have addressed this before without much of a valuable answer, however we 
> seem to have gathered some new info.
> 
> Specs of Director, SD, Postgres-DB (all on one box)
> - 2 Quad-Core Intel Xeon CPUs, 3Ghz each
> - 4GB Ram
> - Postgres-DB on a seperate RAID-Array
> 
> We're running 64bit Debian Etch on the director, Postgres currently is a 8.3, 
> self compiled which came to about a 50% boost as opposed to the 8.1 package 
> we had been running up to last week.
...
> However we have been experiencing problems with the Solaris backups for quite 
> a while now. The database operations are extremely slow as opposed to other 
> systems.

Well, I'm definitely not an experienced PostgreSQL admin, but I guess 
you can get that database to report what it's doing, if there are any 
performance bottlenecks, or if it's idling between short burst of work.

In the latter case, the problem would be inside Bacula. In the former 
case - which I assume you'll find as other jobs run more fluently - 
the key question is what's taking PostgreSQL so long to insert the 
records?

A guess only is that the jobs with the problems have a different sort 
of file and directory names to insert - probably most of them don't 
exist in the database yet.

Or the whole system is getting slow because of resource starvation - 
for example, during the time you run the problem jobs, more backups 
than usual load the database, or some batch jobs need lots of memory 
or CPU, or something.

> Here is an example of a troublesome solaris job:
<snipped examples>
> I really am running out of ideas here. Any input (except rtfm please) is 
> appreciated.

Well, perhaps my ideas from above are a starting point for further 
investigation.

Arno

> Regards
> 
> Ronald Buder
> 

-- 
Arno Lehmann
IT-Service Lehmann
Sandstr. 6, 49080 Osnabrück
www.its-lehmann.de

------------------------------------------------------------------------------
Crystal Reports &#45; New Free Runtime and 30 Day Trial
Check out the new simplified licensign option that enables unlimited
royalty&#45;free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users