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

Vaccum in Vertica? — Vertica Forum

Vaccum in Vertica?

andre_silva

andre_silva ✭

June 2018 in General Discussion

Hello, HP vertica exists the vacuum command like postgresql? if yes, how is the command?
I don't found in web.
Thank's!!

0

Comments

Jim_Knicely - Select Field - Administrator

June 2018 edited June 2018

Probably the PURGE functions in Vertica are the most similar to the VACUUM command in PostgreSQL...

See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkDeletingPurging/PurgingDeletedData.htm

https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkDeletingPurging/ManuallyPurgingData.htm

1
andre_silva ✭

June 2018

Thanks!!

0

Leave a Comment