On Mon, Nov 17, 2008 at 4:03 PM, Pascal Clermont
<pascal-list AT lexum.umontreal DOT ca> wrote:
> Hi,
> Currently spending a lot of time on improving the speeds of this network.
> After several tests I have realized that the database is "inserting
> attributes" was taking quite a lot of time. In order to improve this I
> have searched your forums and see that using batch mode would increase
> this action by 10 times. The guide states:
> " One way is to see if the PostgreSQL library that Bacula will be linked
> against references pthreads. This can be done with a command such as:
>   nm /usr/lib/libpq.a | grep pthread_mutex_lock ".
>
> The file /usr/lib/libpq.a does not exist, I am using postgreSQL 8.3.5
> and did not install from source, but from the package manager that comes
> with the OS, YUM.
>
> Would someone know how I can find out if thread safety is on without
> breaking everything?
> AND if it is on, will Batch Insert Code from bacula work anyways? since
> the file it links against "/usr/lib/libpq.a" is not existent.
>

A second option is spooling the attributes.

http://www.bacula.org/en/dev-manual/Configuring_Director.html#SECTION001430000000000000000

Look for the description of  "Spool Attributes" in the Job resource
documentation.

John

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