Replicated Projections

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

If you are running on a single-node database, all projections are replicated because segmentation is not possible in a single-node database.

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:

For more information about replication, see High Availability With Projections in Vertica Concepts.