Over time, X100 builds up a lot of unused or empty files in its data directory ($II_DATATBASE_ingres/data/vectorwise/<db-name>/CBM/<location-name>) that are no longer used. For example, dropping a table or a column, or system crashes may cause unused or empty files to be left on disk, resulting in low disk space and performance issues. You can remove these files manually or configure automatic cleanup when the X100 server starts.

To manually remove unused files, use the following command:

It deletes the unused files that are either empty or not required, else it moves the unused files to the backup directory with a timestamp of cleanup invocation. For more information, see CLEANUP_UNUSED_FILES Command in the SQL Language Guide.

Any unused files in the backup directory can be configured to expire after a certain retention period using the unused_files_retention_period parameter. Backup directory files exceeding the retention period are automatically deleted.

To invoke automatic cleanup of unused files, configure parameters cleanup_unused_files_on_startup and cleanup_unused_files_default_mode in the vectorwise.conf file.