On 03/08/10, Martin Simmons (martin AT lispworks DOT com) wrote:
> > > > 2. Can I stop this needless after-backup insertion? I tried setting
> > > >    Spool Attributes to NO but it did not work
> > > 
> > > You need to rebuild Bacula with the --disable-batch-insert option, but it
> > > might run quite slowly.  Setting synchronous_commit = off in 
> > > postgresql.conf
> > > might help to make it faster.
> > 
> > Thanks about the note about the --disable-batch-insert compile time
> > option. Changing the synchronous_commit flag to off will speed up
> > inserts into the database which will is great, but it won't affect the
> > size of the batch file. Please clarify why you are suggesting this.
> 
> Sorry, I wasn't clear.  I was only suggesting that you change
> synchronous_commit if you use --disable-batch-insert.

...
> >       Perhaps this is something the developers could consider?
> 
> You can do that already by compiling with --disable-batch-insert and setting
> Spool Attributes to NO.

Thanks very much for your comments, Martin. I'm about to try with this
compile option and setting Spool Attributes to NO.

I'll report back.

-- 
Rory Campbell-Lange
rory AT campbell-lange DOT net

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users