Bump org.questdb:questdb from 9.0.1 to 9.0.2 in /modules/questdb

[dependabot]

Bumps org.questdb:questdb from 9.0.1 to 9.0.2.

Release notes

Sourced from org.questdb:questdb's releases.

9.0.2

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.

... (truncated)

Commits

• 53cea10 [maven-release-plugin] prepare release 9.0.2
• 4428294 chore(ui): upgrade web console to 1.0.2 (#6056)
• 22088ea feat(sql): support array column type in parquet partitions (#5925)
• 5935cce fix(sql): memory leak when querying a table which is being ALTERed concurrent...
• f34f936 fix(core): fix potential File Descriptor leak on table drop (#6053)
• 7454770 test(http): add helper method to test http client (#6054)
• 1839d48 feat(ilp): add reshape() and clear() methods for array reusability (#5996)
• b150294 fix(sql): fix wrong result returned from index lookup query (#6050)
• 312b77d chore(pgwire): remove legacy server code (#6039)
• e461e7d fix(ilp): UnsupportedOperationException when writing to non-WAL table via ILP...
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[eddumelendez]

@dependabot rebase