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 - New Free Runtime and 30 Day Trial Check out the new simplified licensign option that enables unlimited royalty-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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
