Zitat von Mauro <mrsan...@gmail.com>: > On 19 September 2013 21:53, <lst_ho...@kwsoft.de> wrote: > >> >> Zitat von Konstantin Khomoutov <flatw...@users.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users