[Bacula-users] bconsole status dir slow
Hi, I'm using Bacula 1.38.11-7 on Debian Sid with a PostgreSQL 8.1 catalog. We backup about 3TB of data per month over a dozen machines. When i run the bconsole, status dir command, it's really slow; specifically the Scheduled Jobs: section. It takes about 3 minutues to repond. I check to see if the proper indexes were created, and they were. So i turn on statement logging in Postgres. During that one status dir command, Bacula issued over 93,000 select queries. Now that just doesn't seem right. Strange how there are only 1,000 unique commands issues, and even that seems outrageously high. Most of them had the form SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes, JobTDate,Job,JobStatus,Type,Level,ClientId,Name FROM Job WHERE JobId=2431 Any idea what's going on here or why bconsole is so slow? Is this a bug? I couldn't find anything in Mantis. thanks, Brian -- Brian DeRocher @ Noblis This email was signed using OpenPGP. signature.asc Description: This is a digitally signed message part. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bconsole status dir slow
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My understanding is that what it is doing there is checking to see what tapes might be used for these scheduled jobs that are going to occur in the future. How it arrives at that conclusion and what kind of statements it needs to establish that are not things with which I'm familiar. Brian DeRocher wrote: Hi, I'm using Bacula 1.38.11-7 on Debian Sid with a PostgreSQL 8.1 catalog. We backup about 3TB of data per month over a dozen machines. When i run the bconsole, status dir command, it's really slow; specifically the Scheduled Jobs: section. It takes about 3 minutues to repond. I check to see if the proper indexes were created, and they were. So i turn on statement logging in Postgres. During that one status dir command, Bacula issued over 93,000 select queries. Now that just doesn't seem right. Strange how there are only 1,000 unique commands issues, and even that seems outrageously high. Most of them had the form SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes, JobTDate,Job,JobStatus,Type,Level,ClientId,Name FROM Job WHERE JobId=2431 Any idea what's going on here or why bconsole is so slow? Is this a bug? I couldn't find anything in Mantis. thanks, Brian - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - -- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGlPnzmb+gadEcsb4RAqy5AKCqtV/l/Yay+ivwo5Zc75VzFwnyiACdEI5I xF6mi5PiSo6O6+bozIxKr6k= =hFC3 -END PGP SIGNATURE- - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users