CATALOG_TRUNCATION_STATUS

Indicates how up to date the catalog is on communal storage.

Indicates how up to date the catalog is on communal storage. It is completely up to date when the current catalog version is the same as the catalog truncation version.

The catalog truncation version (CTV) is the version that Vertica cluster uses when it revives after a crash, shutdown, or hibernation. A cluster has only one CTV for all nodes in a cluster.

Column Name Data Type Description
CURRENT_CATALOG_VERSION INTEGER The version number of the catalog currently on the cluster.
TRUNCATION_CATALOG_VERSION INTEGER The version number as of the last time the catalog was synced on communal storage.