The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Save a copy of a table in all nodes

Is it possible to save a copy of a table currently in my db across all nodes? Are there any benefits to doing so?

 

 

Thank you!

Comments

  • Hi 

     

    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.

     

     

    Regards

    Rahul Choudhary

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.