The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Buddy projections after lowering K-Safety from 2 to 1

We have a 5 node Vertica cluster that we just lowered the K-Safety from 2 to 1. I see we still have all the _b2 projections though. Do I need to manually drop these or will Vertica handle it in the background? Would the _b2 projections be the **correct ** ones to drop if I need to do it manually?


  • Yes, you can safely remove all the _b2 projections. Vertica won't let you drop any projection it feels like it needs to maintain K-safety.

Leave a Comment

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