Vertica system housekeeping re non deletes



Given that Vertica doesn't delete data, it just marks it as deleted, what happens to it's internal 'system catalogue' when objects are created and dropped ... does this grow and grow until some housekeeping function is performed.


If so, how is this resolved ? I used to work with another MPP (Kognitio) which required a system bounce to clear down its system tables (whereas data tables needed to be moved between 'slabs').


Thanks again.


Leave a Comment

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