Company
Date Published
Sept. 24, 2024
Author
Nick Rycar
Word count
633
Language
English
Hacker News points
None

Summary

Aiven for ClickHouse® has introduced tiered storage, which is now generally available in the Aiven console. This feature combines the speed of ClickHouse with the cost optimization of object storage to create a powerful data warehouse solution. Tiered storage can be enabled on a per-table basis and allows users to optimize costs by using object storage alongside existing SSD storage. By default, once an Aiven for ClickHouse instance's SSDs hit 80% capacity, data is automatically moved to object storage. This behavior can be further refined by creating an explicit TTL or manually moving data as needed. The tiered storage feature is useful in scenarios where query performance can be traded off for cost optimization, such as logs management.