ebollengier wrote:
> 
> 
> 
> Jason Dixon-6 wrote:
>> 
>> On Wed, Nov 12, 2008 at 12:56:21AM -0800, ebollengier wrote:
>>> 
>>> Hello,
>>> 
>>> The batch mode improve the speed with postgresql by a factor of 10
>>> (maybe
>>> 20), using
>>> a very big job (15M files) with the standard mode won't work too.
>> 
>> I don't understand what you're saying.  Are you suggesting that either
>> way I won't be able to perform this backup due to the number of files?
>> 
> 
> The backup is possible, but your configuration (hardware and software)
> needs to be able to 
> do this big insert. For example, if you have only 256MB for ram and 1 poor
> old ide drive, it 
> will take some time.
> 
> I just say that the old "per file" insertion mode will take 10 more time,
> and it's already too 
> long for you.
> 
> With Postgres, you can run your catalog backup at the same time than other
> jobs (try to 
> avoid having 10 jobs during this job)
> 
> Bye
> 

Look at http://pastebin.com/m32969087

I have run 2 batch transaction at the same time, and as you can see that all
locks are "granted", and exclusive locks are not global. So no deadlock and
all run fine.

Are you sure that your system is frozen ? (no io, no cpu)

Maybe you can modify the fileid sequence to have a bigger cache. (by default
it 1, so you 
may have contention)

Bye

-- 
View this message in context: 
http://www.nabble.com/Hung-on-%22Dir-inserting-attributes%22-tp20450040p20477892.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


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