Skip to content
HeliosDB Full

Storage Engine

Storage Engine

High-performance LSM-tree based storage with intelligent compaction and tiering.

Overview

HeliosDB’s storage engine is built on an optimized LSM-tree architecture with:

  • Intelligent compaction strategies
  • Hot/warm/cold data tiering
  • Columnar storage optimization
  • Hardware-accelerated compression

Quick Start

-- Configure storage tier
ALTER TABLE logs SET STORAGE TIER 'cold'
  WITH (compression = 'zstd', compression_level = 9);


-- Set compaction strategy
ALTER TABLE events SET COMPACTION STRATEGY 'leveled'
  WITH (level_size_ratio = 10, max_bytes_for_level_base = '256MB');


-- Monitor storage usage
SELECT * FROM helios_storage_stats;

Key Features

FeatureDescription
LSM-TreeWrite-optimized with configurable compaction
Tiered StorageHot, warm, cold data management
CompressionLZ4, Zstd, Snappy with level tuning
ColumnarColumn-oriented storage for analytics
Bloom FiltersFast negative lookups

Documentation

DocumentDescription
LSM_TUNING_GUIDE.mdLSM-tree configuration
COMPACTION_STRATEGY_GUIDE.mdCompaction strategies
  • Performance Tuning: /docs/guides/user/PERFORMANCE_TUNING_GUIDE.md
  • Backup & Recovery: /docs/guides/user/BACKUP_RECOVERY_GUIDE.md

Status: Production Ready Version: v7.0