On 04/24/2014 11:37 AM, Lloyd Brown wrote:
> Alan,
> 
> I understand.  I've been meaning to get started with learning Postgres
> for several years, but there always seems to be something more urgent
> that takes my attention away.  At the moment, it's storage system
> failures, which is kinda a big deal, so for now I'll have to be content
> with the tuning's I've applied on MySQL.

Keep in mind that postgres is not made of silver bullets either: you
still need to give it enough ram, i/o, and cpu cores to get adequate
performance on large joins (e.g. building a list of backed up files form
a year's worth of backups of a few million files). However, IMO even if
you have to buy a complete new server for it, that's much cheaper than
dealing with mysql.

-- 
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

signature.asc
Description: OpenPGP digital signature

------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users