-----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
