Re: [Bacula-users] Bacula + Postgres : copy batch problem
2010-08-03 18:39:54
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
|
|
|