Is it possible to save a copy of a table currently in my db across all nodes? Are there any benefits to doing so?
You can created replicated(unsgemented projection) for this table in order to achieve this.
For your information this can be achieved only and DBD recommends that a projection be replicated if any one of the following is true:
Condition 1: largest-row-count < 1,000000 and number of rows in the table <= 10% of largest-row-count.Condition 2: largest-row-count >= 10,000,000 and number of rows in the table <= 1% of largest-row-count.Condition 3: The number of rows in the table <= 100,000.
Replication provided below advantages:
=> Distributed query execution across multiple nodes.
=> High availability and recovery. In a K-safe database, replicated projections serve as buddy projections.This means that a replicated projection on any node can be used for recovery.
I hope this answers your question.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.