Vaccum in Vertica?

8 years ago
Jun 12, 2018 2:52 PM UTC
2 replies
14 views

Forum|alt.badge.img

andre_silva
Participating Frequently

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

Forum|alt.badge.img

+2

Jim_Knicely
Participating Frequently
8 years ago
Jun 12, 2018 7:04 PM UTC

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

Like

Forum|alt.badge.img

andre_silva
Author
Participating Frequently
8 years ago
Jun 18, 2018 7:31 PM UTC

Thanks!!

Like