Zitat von Dimitri Maziuk <dmaziuk AT bmrb.wisc DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users