v.23.11Improvement

Allow Manual Compaction of EmbeddedRocksDB via OPTIMIZE Query

Official CH changelog text
Allow manual compaction of EmbeddedRocksDB via OPTIMIZE query. #56225 (Azat Khuzhin).
Added support for manual compaction of EmbeddedRocksDB storage engine using the OPTIMIZE query in ClickHouse.

Why it matters

This feature allows users to manually trigger compaction operations on EmbeddedRocksDB tables. It addresses the need for better control over data storage optimization, improving query performance and storage efficiency by consolidating SST files on demand.

How to use it

Users can trigger manual compaction by executing the OPTIMIZE TABLE <table_name> query on tables using the EmbeddedRocksDB engine.

Related resources

PreviousNext