> I'll try tuning things if you can get the data to me, or give me > access to the database. It's not always indexes. Sometimes it's > more along the lines of queries or vacuum.
While setting up access to my data, I copied my bacula database to a new database and had quite an unexpected result. The query runs fast enough under the new database while still running slowly on the old one. I am running pg_autovacuum (and I ran one by hand recently to see if that would help) so I'm surprised that re-creating the database would make this kind of difference. -- Karl Hakimian [EMAIL PROTECTED] ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users