Zitat von Mauro <[email protected]>: > On 19 September 2013 21:53, <[email protected]> wrote: > >> >> Zitat von Konstantin Khomoutov <[email protected]>: >> >> >> 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
