We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Buddy projections after lowering K-Safety from 2 to 1 — Vertica Forum

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