On 08/11/10 22:21, Gavin McCullagh wrote: > > Right you are.... > > http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog > > There is still an element of "move to postgresql" though >
With good reason. I did resist moving to pgsql for quite a while but it does work better. > We seem to have the correct indexes on the file table. I've run optimize table > and it still takes 14 minutes to build the tree on one of our bigger clients. > We have 51 million entries in the file table. > Add individual indexes for Fileid, Jobid and Pathid Postgres will work with the combined index for individual table queries, but mysql won't. AB ------------------------------------------------------------------------------ The Next 800 Companies to Lead America's Growth: New Video Whitepaper David G. Thomson, author of the best-selling book "Blueprint to a Billion" shares his insights and actions to help propel your business during the next growth cycle. Listen Now! http://p.sf.net/sfu/SAP-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
