QuestDB Files

Release 9.0.1 brings notable enhancements to SYMBOL indexes, along with several bug fixes.

First, Materialized Views now support indexed symbols, improving performance for workloads that rely on large views with numerous symbols. The index capacity is inferred automatically, though it can be manually configured if needed.

Second, we've significantly optimized index performance under high concurrency. If your workload is both index and concurrency intensive, you can expect a 10x–100x speedup compared to 9.0.0.

For any questions or feedback, please join us on Slack or on Discourse.

See also our prettier release notes page.

Changelist

• fix(sql): array NULL comparison failure by @bluestreak01 in https://github.com/questdb/questdb/pull/5935
• fix(sql): produce actionable error message when MV is created from select with illegal column aliases by @bluestreak01 in https://github.com/questdb/questdb/pull/5945
• fix(sql): DISTINCT query with table alias expresions will throw error Invalid table name or alias by @kafka1991 in https://github.com/questdb/questdb/pull/5946
• fix(sql): Fix database not preserving column alias casing in SQL by @RaphDal in https://github.com/questdb/questdb/pull/5948
• feat(core): add data_id with current_data_id() SQL function by @RaphDal in https://github.com/questdb/questdb/pull/5917
• perf(sql): improve performance of symbol index lookups by @bluestreak01 in https://github.com/questdb/questdb/pull/5953
• fix(sql): exception when JIT compiling a filter like WHERE symbol = '''' by @nwoolmer in https://github.com/questdb/questdb/pull/5958
• feat(sql): add support for indexing of symbol columns in materialized views by @bluestreak01 in https://github.com/questdb/questdb/pull/5961
• fix(core): fix table suspension due to indexing error by @bluestreak01 https://github.com/questdb/questdb/pull/5984

Full Changelog: https://github.com/questdb/questdb/compare/9.0.0...9.0.1