Recovery By Table

Vertica supports node recovery on a per-table basis. Unlike a node-based recovery, recovering by table makes tables available as they recover, before the node itself is completely restored. You can prioritize your most important tables to ensure that they become available as soon as possible. Recovered tables support all DDL and DML operations.

To enhance recovery speed, Vertica recovers multiple tables in parallel. The maximum number of tables recoverable at one time is governed by the MAXCONCURRENCY parameter in the RECOVERY resource pool.

Once a node has fully recovered, it enables full Vertica functionality.

Recovery by table is enabled by default.

Note: Vertica does not support recovery by table for tables with pre-join projections.

Enabling Recovery by Table

With all the nodes in your cluster up, enable recovery by table with the following query:

SELECT SET_RECOVER_BY_TABLE('true');

Important: Do not disable recovery by table. SET_RECOVER_BY_TABLE has been deprecated and will be removed in a future release