Francisco Reyes writes: > Francisco Reyes writes: > >> Using Bacula 1.38.11 in FreeBSD 6.1 >> Using disk volumes. >> >> I have a pool with a large set of Purged volumes, yet Bacula continues to >> make new volumes in the pool. > > Better queries. > > To get count. > > select count(*) > from media where volstatus = 'Purged' and recycle = 1 and > volretention/(3600*24) < (CURRENT_DATE-lastwritten::date)::int > > To see them > select volumename,mediatype,firstwritten::date,lastwritten::date, > labeldate::date,volstatus,recycle, > volretention/(3600*24) as Retention, (CURRENT_DATE-lastwritten::date)::int > as Age > from media where volstatus = 'Purged' and recycle = 1 and > volretention/(3600*24) < (CURRENT_DATE-lastwritten::date)::int > limit 10; > > Anyone else using postgresql and disk volumes could try these queries to see > if they are experiencing simmilar issues? > > On my setup I find 358 volumes which are purged, marked for recycle and with > last_writen greater than the expiration date. This, in my case, adds up to > 716GB of dead space!!
Not that it matters, but my volumes are only 1GB, not 2GB.. but still that is 358GB of wasted space. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
