The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Vertica Backup Objects

AnuskaWRAnuskaWR
edited August 13 in General Discussion

When comparing storage usage on 4 nodes in our cluster, I noticed that a lot of size is occupied by backups (namely in Objects \backups\Objects location). I used vbr -t -remove -c backup.ini to remove old archived backups (we keep 4) , but the size of the Objects did not go down at all.
Next, I ran two commands:
vbr -t quick-repair -c configfile.ini
vbr -t collect-garbage -c configfile.ini --report-file=path/filename
Some old objects seemed to be deleted. but they only accounted for about 60GB of space. Since I deleted 2 archive backups, I expected the size of the Objects to go down 50%, but it didn't. The size of backups folder decreased from 830 to 760 GB only.

What it takes to fully remove all backups? Does backup\Objects holds some other files needed by Vertica?

Comments

  • Bryan_HBryan_H Employee

    Hi, I'm under the impression that backups with restore points only capture deltas but may appear to be full size because the deltas contain "hard links" or filesystem pointers to the most recent copy of an object. So when you delete one backup, you might only be deleting one changeset. I think the previous thread indicated you would need to pass a flag to delete "all" backups.

  • I did not remove "all" backups b/c one of them was taken before adding a node, so I removed each archive (done after adding a node) individually. Just could not understand why the size of backups hardly changed if all backups done after adding a node were removed.
    After internal discussion, we decided to run "all' and the Objects size decreased to 15 MB.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.