Download Latest Version questdb-9.0.2-rt-linux-x86-64.tar.gz (70.4 MB)
Email in envelope

Get an email when there's a new version of QuestDB

Home / 9.0.2
Name Modified Size InfoDownloads / Week
Parent folder
questdb-9.0.2-no-jre-bin.tar.gz 2025-08-15 26.5 MB
0
questdb-9.0.2-rt-linux-x86-64.tar.gz 2025-08-15 70.4 MB
0
questdb-9.0.2-rt-windows-x86-64.tar.gz 2025-08-15 62.6 MB
0
9.0.2 source code.tar.gz 2025-08-15 56.1 MB
0
9.0.2 source code.zip 2025-08-15 60.9 MB
0
README.md 2025-08-15 5.8 kB
0
Totals: 6 Items   276.5 MB 0

QuestDB 9.0.2 Release Summary

9.0.2 is a performance and stability release. It accelerates common query patterns, reduces resource usage, and adds quality-of-life features across SQL, the PostgreSQL wire protocol (PGWire), ingestion, and operations.

Highlights

ORDER BY … LIMIT, now parallelised. Sort-and-limit queries execute much faster on large datasets — up to 10× in internal tests.

Dedicated thread pools. Reads, writes, and network operations run on separate pools for better isolation and predictable latency under load.

Array improvements. New functions array_stddev(), array_min(), and array_max(); support for negative indexing (e.g., array[-1] for the last element); and improved Parquet compatibility for array columns.

Lower resource footprint. File descriptors and memory maps are cached more aggressively. CSV import is faster (especially for VARCHAR), and materialized views do less I/O with small SAMPLE BY intervals.

SQL & Ingestion Protocol

TRUNCATE IF EXISTS avoids errors when truncating a table that may not be present.

PostgreSQL wire protocol (PGWire): improved handling of bind variables for more predictable prepared-statement behaviour.

Ingestion clients for ILP: helpers reshape() and clear() make array reuse simpler and reduce allocations.

Performance

Parallel ORDER BY + LIMIT delivers markedly lower end-to-end latency for top‑N queries.

Thread-pool separation prevents read workloads from contending with writers or network services during spikes.

Faster CSV import for VARCHAR-heavy payloads via improved parsing and reuse.

Reliability & Operations

CPU spike resolved in specific concurrent workloads.

Window functions: intermittent failures addressed.

Index lookups: corrected edge cases that could yield wrong results.

WAL lag metrics now persist across restarts for continuous observability.

Native libraries are no longer placed under /tmp, aligning better with hardened security policies.

Contributors

Thanks to first‑time contributors:

@TaniyaKatigar, @aleksandarskrbic, @akashadsare, @gauravjain0377

Thank you to everyone who reported issues and shared production insights — your feedback powers QuestDB.

Changelist

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

Source: README.md, updated 2025-08-15