Optimize Tables

Learn about typical DBA performance optimization operations, such as consolidation and vacuuming.

Traditional SQL databases have commands such as OPTIMIZE TABLE, which perform physical and logical maintenance on a table to optimize performance. TileDB’s version of OPTIMIZE TABLE comprises consolidation and vacuuming. These operations allow for physical compaction of an array and its fragments (which act like versions), which can yield performance improvements for reads and writes, along with potential on-disk storage size reduction due to improved compression from consolidation, or removal of obsolete data from vacuuming.

Some databases such as PostgreSQL also have additional operations such as VACUUM. TileDB has the same concept of vacuuming, but does not support auto-vacuuming, thus you must trigger this operation manually.