Dropping Partitions Due to Space Constraints

If your hardware has fixed disk space, you might need to configure a regular process to roll out old data by dropping partitions.

For example, if you have only enough space to store data for a fixed number of days, configure Vertica to drop the partition with the oldest date. To do so, create a time-based job scheduler, such as cron, to drop the partition on a regular basis during low-load periods.

If the ingest rate for data has peaks and valleys, you can use two techniques to manage how you drop partitions:

For more information about partitions, see the following sections in the Vertica documentation: