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

Determining the Current K-Safety

Jim_KnicelyJim_Knicely Administrator
edited January 2019 in Tips from the Team

K-safety sets the fault tolerance in your Vertica database cluster. The value K represents the number of times the data in the database cluster is replicated. These replicas allow other nodes to take over query processing for any failed nodes.

You can view the current K-Safety of a Vertica database in several ways.


dbadmin=> SELECT get_design_ksafe();
(1 row)

dbadmin=> SELECT current_fault_tolerance FROM system;
(1 row)

Helpful Links:

Have fun!

Sign In or Register to comment.

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