Zitat von Konstantin Khomoutov <flatw...@users.sourceforge.net>: > On Thu, 19 Sep 2013 17:06:48 +0200 > Mauro <mrsan...@gmail.com> wrote: > >> Hello. >> I'm using bacula in a linux debian system. >> I've to backup about 30 hosts. >> I've choose postresql as database. >> What do you think about? >> Better mysql or postgres? > > Unless you will have directories with unusually high quantities of > files on those hosts (for instance, backup directories maintained by > rsnapshot, huge mail spools etc) both should perform well. > > The basic idea is that each (full) filename backed up makes up one > record in one of the tables of the Bacula catalog, plus each unique > pathname makes up one record in its another table. Consequently, when > you have *huge* number of distinct files in a backup job, this might > kneel your database. I've personally seen despooling of attributes for > some 800k files taking more than 24 hours with a reasonably tuned (for > high-memory) MySQL instance using the MyISAM storage backend. I'm not > sure would Postrges beat MySQL in this situation, and if yes then by > which margin. In this particular case I've just switched to using the > bpipe plugin for backing up that particular fileset -- simply because > restoring individual files from it makes little sense anyway. >
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. If you are familiar with Postgres there is no reason to not use it. 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
