Home / Companies / QuestDB / Blog / Post Details
Content Deep Dive

QuestDB 9.3.2: TICK, arg_max, and Exponential Moving Averages

Blog post from QuestDB

Post Details
Company
Date Published
Author
Javier Ramirez
Word Count
1,009
Language
English
Hacker News Points
-
Summary

QuestDB 9.3.2 introduces significant advancements in the realm of time-series databases, notably with the introduction of TICK, a new temporal interval syntax that simplifies complex time-range filters into concise expressions. This release enhances SQL capabilities with new aggregate and window functions, including arg_min, arg_max, and geomean, alongside EMA and VWEMA for time-series analytics. It offers a 6x speedup on Parquet queries, improved large language model (LLM) integration, and enhanced AI assistant functionality in the web console. Additionally, QuestDB Enterprise 3.2.1 supports scheduled incremental backups to object storage, optimizing both speed and bandwidth efficiency. The comprehensive refresh of documentation facilitates easier navigation, while performance improvements ensure faster query execution and reduced file mapping contention. Overall, QuestDB 9.3.2 empowers users with a robust toolkit for efficient and effective data analysis, encouraging experimentation with its innovative TICK feature.