On 8/14/2013 2:41 PM, Dimitri Maziuk wrote: > 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.
We put the db on Intel 710 series SSD a while ago and it made a HUGE difference even without upgrading cpu or ram. ------------------------------------------------------------------------------ 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
