Skip to main content
Question

Per-partition storage

  • February 17, 2021
  • 1 reply
  • 2 views
reli
Forum|alt.badge.img+1
  • reli
  • Participating Frequently

In this link: 0.jpghttps://www.youtube.com/watch?v=j-xo0CyGk7Q
in Feature 6#: Per-partition storage -store old parts of the data in a cheaper store.
how can I do that? I can store part of the data in Vertica and part (the old parts) in the S3 store in the same table?

    1 reply

    Bryan_H
    Forum|alt.badge.img+2
    • Bryan_H
    • Participating Frequently
    • February 18, 2021

    In an EE mode database, you can set storage locations for data on local disk and S3, then set a storage policy directing old partitions onto S3 location and a policy for current data on local disk. Please see:
    https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/AdministratorsGuide/StorageLocations/CreatingAndConfiguringStorageLocations.htm
    The most relevant sections are on "Creating Storage Locations" to create the storage locations on local disk and S3 and "Creating Storage Policies for Low-Priority Data" to assign partitions to the storage locations.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement