We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Estimate Incremental Backup Size — Vertica Forum

Estimate Incremental Backup Size

avi120avi120 ✭
in General Discussion

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;
Tagged:

Answers

  • V_LearnerV_Learner ✭

    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,

  • avi120avi120 ✭

    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...