Skip to main content

Vaccum in Vertica?

  • June 12, 2018
  • 2 replies
  • 8 views
andre_silva
Forum|alt.badge.img

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

    2 replies

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • June 12, 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

    andre_silva
    Forum|alt.badge.img
    • andre_silva
    • Author
    • Participating Frequently
    • June 18, 2018

    Thanks!!

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement