Enhanced SQL Performance and New Data Types
QuestDB 8.0, an open-source time series database, now features a new default VARCHAR data type, replacing STRING. This change aims to enhance data compression and performance. SQL query performance has improved by 50%, with optimized data ingestion rates reducing latency and increasing throughput. The updated SQL compiler and new functions further enhance time series analytics capabilities.
ZFS Compression for Better Storage Efficiency
The storage engine now supports ZFS compression, offering up to 6x better storage utilization. This system-level compression improves query performance by reducing the data read from disks, accelerating data retrieval and analysis.
Default Memory Allocator Changes
The release also includes changes like a GLIBC upgrade, modifications to ILP and TextImport, and switching the default memory allocator to jemalloc.
Optimized Storage Engine
QuestDB employs a columnar storage model, which is particularly effective for time series data, improving data compression and read access speed. This model allows for more efficient execution of analytical queries by reading only relevant columns.
Learn More Interested readers can find more details in the version 8.0 release notes on GitHub.
Experts in development, customization, release and production support of mobile and desktop applications and games. Offering a well-balanced blend of technology skills, domain knowledge, hands-on experience, effective methodology, and passion for IT.
