Op 17/01/2011 22:39, Rory Campbell-Lange schreef: > On 17/01/11, Devin Reade (g...@gno.org) wrote: >> ... I don't recall having seen anywhere a recommendation of Postgres >> over MySQL (or vice versa) or a statement about significant benefits >> of one vs the other. > This isn't Bacula specific, but there is an interesting page on the > Postgresql wiki about the differences between MySQL and Postgresql here: > http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 > which is a little out of date. > From what I've come to know by reading the mailing list, most of (if not all) SQL queries bacula uses are optimized for Postgresegl. As long as your catalog doesn't get huge, it won't make much of a difference if you're using MySQL or Postgresql. If it does gets huge tho it seems a MySQL database needs quite a bit more tweaking to get good performance because the queries aren't really optimal for it.
Kind regards, Jeremy **** DISCLAIMER **** http://www.schaubroeck.be/maildisclaimer.htm ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
