[Bacula-users] Better way to garbage collect postgresql database
2009-03-19 14:37:19
Folks,
This is a database question, but I figured some of the bacula users may have
come across this problem so I am posting it here.
Every monday I run following commands to check and garbage collect bacula
database:
dbcheck command
vacuumdb -q -d bacula -z -f
reindexdb
Usually I purge one or two backup volumes and the above commands run in less
than 20 minutes.
Before my monthly Full backup I delete large amount of data from the database
as I delete one month worth of Full and Incremental backups. When I run the
above commands after the Full backup, the vacummdb command take 12 hours to
run. Is there a faster/better way of doing it?
My database is about 9GB.
If I backup database using pgdump and then restore it, will it do the same
thing as vacuumdb and reindexdb commands?
Thanks.
Hemant Shah
E-mail: hjrrs AT yahoo DOT com
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Bacula-users] Better way to garbage collect postgresql database,
Hemant Shah <=
|
|
|