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?

Answers

  • 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
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.