identify modified objects for incremental backup

Hi! Vertica sores data in special structure that Vertica calls - containers. Containers can be created or deleted and never re-written. Each container has it own OID. If some file for OID missing in it location - means objects have been modified. Other way to find all modified objects: to check hard links in Snapshot. If some hard link exists in the Snapshot directory, that has only one reference - means that this container have been modified. select * from storage_containers; https://community.vertica.com/vertica/topics/how_is_data_stored_in_vertica

thanks Daniel! very helpful! P.