Replicated projections

Replication occurs when Vertica stores identical copies of data across all the nodes in your cluster.

Assuming that largest-row-count equals the number of rows in the design table with the largest number of rows, Database Designer recommends that a projection be replicated if any of the following conditions is true:

• largest-row-count < 1,000,000 and number of rows in the table <= 10% of largest-row-count

• largest-row-count >= 10,000,000 and number of rows in the table <= 1% of largest-row-count

• The number of rows in the table <= 100,000

For more information about replication, see High availability with projections.