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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
