Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!


I just created a new vertica database and have not used database designer. By default what's the k-safety. And, with K-safety 1 how many copies are stored? I am assuming 2.


  • if you have 3 nodes by default is k-safe=1 and it will have 2 copy of the data. in the system table, select * from system;, there is a colum named desing fault tolerance and that indicate the k-safe that your database is. Hope this helps, Eugenia
  • If you have a 3nodes database cluster, which is the minimum required for K safety, then the K-safety value by defualt is 1. You can use increase your k safety to 2. If k safety 1 = 2 copies of each projection k safety 2 = 3 copies of each projection

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.