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:
- 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 in Vertica Concepts.