Zitat von Mauro <mrsanna1 AT gmail DOT com>:

> On 19 September 2013 21:53, <lst_hoe02 AT kwsoft DOT de> wrote:
>
>>
>> Zitat von Konstantin Khomoutov <flatworm AT users.sourceforge DOT net>:
>>
>>
>> Our biggest single job has about 1TB data with some 3.3 million files.
>> This lead to around 1GB spooled attributes which will be absorbed in
>> less then 2 minutes. Database is Postgres with some minimal tuning:
>>
>> shared_buffers = 128MB
>> temp_buffers = 32MB
>> work_mem = 32MB
>> maintenance_work_mem = 64MB
>> checkpoint_segments = 32
>> checkpoint_completion_target = 0.9
>>
>> That's all
>>
>> Database hovers around 21GB in size with with some 57 million rows in
>> the file table.
>>
>
> how much ram you have in your server?

The whole server has 8GB, but that only needed for Bacula director in  
case of restoring some million files ;-)

Regards

Andreas



------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users