The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Vertica system housekeeping re non deletes

Hi,

 

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.

Comments

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.