May 2022 Summaries

QuestDB 6.3 introduces significant performance enhancements by enabling parallel SQL filter execution and JIT compiled filters by default, which notably reduces query execution times. In a benchmark competition against TimescaleDB and ClickHouse, QuestDB demonstrated superior performance in executing queries, especially without the need for index-based scans, thanks to its parallelism-friendly storage model. The benchmark involved generating and querying a large dataset of IoT device measurements, where QuestDB consistently outperformed its competitors in both cold and hot query execution scenarios. The introduction of parallel SQL filter execution allows QuestDB to efficiently utilize multi-core systems by dividing data into chunks or "page frames" and processing them concurrently, which is particularly useful for queries with large datasets or multiple partitions. Furthermore, the batch-based filter processing model, similar to JIT compilation, enables faster execution by tightly looping through filter functions and storing results in an intermediate array. These optimizations mark a significant step in QuestDB's ongoing development, with plans for further improvements in processing aggregate queries and function push-down optimizations. Users are encouraged to try the new release and provide feedback, with community contributions welcomed.

QuestDB is an advanced open-source database designed for market data, particularly excelling in handling tick data and cryptocurrency price trends. It provides high ingestion throughput and enhanced SQL analytics capabilities, allowing for efficient real-time analysis and further investigations. QuestDB also emphasizes cost-saving hardware efficiency by utilizing open formats, making it a suitable choice for high-performance data operations.

QuestDB 6.3, an open-source time-series database designed for high-demand workloads, introduces several enhancements focused on performance and usability, informed by community and customer feedback. Key updates include multi-threaded SQL execution for improved performance in filter queries, optimized query cache retention, and support for cloud-native filesystem snapshots enabling live database backups with minimal impact. The release also boasts performance optimization for LATEST ON syntax over un-indexed symbol columns, providing significant gains without needing indexes, and introduces a read-only mode for connections via the PostgreSQL Wire Protocol. Additionally, the web console now features SQL syntax formatting and table name autocomplete, enhancing user convenience.