Resize cluster 3 => 1, unused buddies
After resizing a cluster from multiple nodes that have ksafe=1 down to a single node with ksafe=0 there are still all the "_b1" buddy projections around.
Does Vertica recommend a way to clean these out? As I understand they are just duplicated super projections at this point.
0
Comments
I think you'll need to drop the b1 projections yourself, but it's really easy to automate the drops..
Example:
Be careful! First run this command and make sure the DROP commands are for the projections you want to DROP!
vsql -Atc "SELECT 'DROP PROJECTION ' || projection_schema || '.' || projection_name || ' CASCADE;' FROM projections WHERE is_segmented LIMIT 1 OVER(PARTITION BY anchor_table_id ORDER BY projection_schema, projection_name DESC);"
In the example above the output from that command are a series of DROP PROJECTION commands that are piped through vsql where they'll run.