The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Estimate Incremental Backup Size

Hi all,

I know I can run the following query to get an estimation of full backup size. However, can I possibly estimate the backup size of an incremental backup that is executed after we already backed-up the database few days ago.

 select node_name, sum(used_bytes) / ( 1024^3 ) as size_in_gb 
 from v_monitor.storage_containers 
 group by node_name;

Answers

  • Hi,
    You could probably try to archive the data of the storage_containers table into a separate schema for yesterday's data, and compare it with today's size. You will see the change in the size of the same to check the incremental backup size,

  • Thanks for the reply. Will your suggestion still work if 100 GB were deleted and 100 GB were inserted since that last backup?

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.