Zitat von Alan McKay <alan.mckay+bacula AT gmail DOT com>:

> OK, I know some of you guys are biased here because I recognise some
> of the names from my pgsql days :-)
>
> I've been googling to find MySQL tuning instructions for bacula but
> not much is coming up.   Though I did find a 2 or 3 year old
> discussion from this list which suggested I'd get better performance
> from pgsql anyway.    I certainly don't know pgsql as well as MySQL,
> but I did used to know a fair bit about it and switching would not be
> that big a deal to me.

For most sites it doesn't really matter. If you know how to operate  
MySQL, use i
it and it will work. If you have some specific needs you have to do  
performance evaluation anyway.

> So what do you think?
>
> Anyone have any specific links for MySQL + Bacula tuning?
> Anyone have any datapoints on MySQL vs pgsql for Bacula?
>
> Will pgsql still have to be tuned?

With PostgreSQL there are four parameters to tune:

- shared_buffers : Should be raised to something reasonable in the  
range of some 100 M
- checkpoint_segments and checkpoint_completion_target : Something  
about 10 - 20 segments should be fine and the completion target of 0.9  
will smooth out writes
- work_mem : The higher the more sorts are RAM based. This should  
speedup for example bvfs operation

All taken from here:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

Regards

Andreas



------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users