Purge Process

Moderator: NorbertKrupa

Post Reply
adrian.oprea
Intermediate
Intermediate
Posts: 163
Joined: Tue Jun 19, 2012 2:44 pm
Location: Rio de Janeiro
Contact:

Purge Process

Post by adrian.oprea » Mon Feb 25, 2013 6:48 pm

Hy everybody ,
I have some doubts about how Vertica handles the delete during the margeout process ?
Corect me if i am wrong :
- Vertica never updates files !
- Vertica will always create vector on the delete records marked for delete !

So does vertica writes the vectors on a new file and when mergeout /purge runs the files are used to recreate the rest of the data left in the deleted objects table ?
trying so hard !!!

Post Reply

Return to “New to Vertica Database Administration”