Zitat von Dimitri Maziuk <dmaz...@bmrb.wisc.edu>: > On 08/14/2013 01:13 PM, azurIt wrote: >>> Where's my mistake? Could you suggest me some optimization. >> >> Hi, >> >> only one little suggestion from me - upgrade to MySQL 5.5. > > I didn't have much luck with postgres on a single-cpu (I think 6-core or > maybe 4) and 8 or 12GB RAM (it's off at the moment & can't find the > printed specs). > > Our current server for "big" backups is dual quad-core xeon with 48GB > RAM and hardware raid, running postgres 8.4 -- *that* doesn't take hours > to run the queries.
Our test machine with a single SATA need around 5 minutes for building the tree for a 4.2 million file backup. The main machine with SSD is somewhat faster. Both run Bacula with PostgreSQL 9.1 and only tuned five parameters in postgresql.conf. Not sure how you get hours for the file tree in bconsole. If you are using Bat and bvfs that would be another story. Regards Andreas ------------------------------------------------------------------------------ Get 100% visibility into Java/.NET code with AppDynamics Lite! It's a free troubleshooting tool designed for production. Get down to code-level detail for bottlenecks, with <2% overhead. Download for free and get started troubleshooting in minutes. http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users