Hello, On 02/12/2016 05:25 PM, Martin Simmons wrote: >>>>>> On Thu, 11 Feb 2016 18:10:52 -0500, Dan Langille said: >> >> I am still looking at this, mostly because of this issue: >> >> 07-Feb 18:01 crey-sd JobId 230447: Sending spooled attrs to the Director. >> Despooling 422,031,119 bytes ... >> 08-Feb 01:31 bacula-dir JobId 230447: Bacula bacula-dir 7.4.0 (16Jan16): >> >> FD Files Written: 1,365,074 >> FD Bytes Written: 332,924,576,236 (332.9 GB) >> >> The above is the original job. The following is the copy to tape: >> >> 09-Feb 00:24 crey-sd JobId 230519: Sending spooled attrs to the Director. >> Despooling 422,031,119 bytes ... >> 09-Feb 06:57 bacula-dir JobId 230516: Bacula bacula-dir 7.4.0 (16Jan16): >> >> SD Files Written: 1,365,074 >> SD Bytes Written: 333,216,925,325 (333.2 GB) >> >> The first job spends about 5.5 hours getting attributes into the database. >> The second job spends about 6.5 hours. > > Unless I've misunderstood something, your speed is very much slower than min. > For me, inserting a similar sized job takes less than 2 minutes:
Thanks to both of you, I have also this kind of results. However, Dan is pointing an interesting problem. The query that forces the nested loop plan looks to work much better in some cases, but in an other hand, if the index is not in memory (mostly because the server is not doing only Postgres and Bacula), the result of the query might be catastrophic... and I can't really say what is the best way. So, it's not an easy choice, maybe only the end user can decide between the two (with a directive for example). Thanks for your feedback. Best Regards, Eric -- Need professional help and support for Bacula ? Visit http://www.baculasystems.com ------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
