QuestDB 9.2.2 is another stability release, primarily fixing some query snags. With this, we've packaged a performance improvement for vertically-scaled machines, and some new SQL functions.

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

See also our prettier release notes page.

Breaking changes 💥

• We've removed the legacy txn scoreboard (v1).
  • Using the new scoreboard (v2) has been the default for some time now.
  • If you have been manually overriding this config option (cairo.txn.scoreboard.format=1), it will no longer take effect, but the instance will boot and function as normal.
• MANUAL PERIOD views will now only be refreshed by manual trigger, and not also automatically when the time period ends.
  • This was always the intended behaviour; it is unexpected that a MANUAL view should refresh automatically.

SQL

New weighted statistics functions

• weighted_avg(DD) - computes the weighted average based on a 'value' column and a 'weights' column.
  • A straightforward weighted average calculation.
• weighted_stddev_rel(DD) - computes the weighted standard deviation based a 'value' column and a 'reliability weights' column.
  • Reliability weights are based on how trusted or reliable the particular value should be treated.
• weighted_stddev_freq(DD) - computes the weighted standard deviation based on a 'value' column and a 'frequency weights' column.
  • Frequency weights are based on the frequency of a particular sample occurring in the dataset.

Changelist

• fix(sql): fix bug where queries using IN clauses with INT/LONG columns containing -1 return incorrect results. by @kafka1991 in https://github.com/questdb/questdb/pull/6439
• fix(sql): fix internal error when concurrent threads try to drop a non-wal table by @jerrinot in https://github.com/questdb/questdb/pull/6462
• fix(pgwire): fix protocol corruption when sending arrays from server to client by @bluestreak01 in https://github.com/questdb/questdb/pull/6455
• fix(core): breaking change 💥 - remove tx scoreboard v1 by @jerrinot in https://github.com/questdb/questdb/pull/6449
• fix(sql): breaking change 💥 - inconsistent data in chained period materialized views by @puzpuzpuz in https://github.com/questdb/questdb/pull/6463
• fix(core): fix a bug where default ILP decimal wouldn't be null by @RaphDal in https://github.com/questdb/questdb/pull/6454
• fix(core): fix internal errors due to bad implicit casting by @jerrinot in https://github.com/questdb/questdb/pull/6443
• perf(sql): improve query scalability on large multicore machines by @puzpuzpuz in https://github.com/questdb/questdb/pull/6459
• fix(pgwire): batch SELECTs with bound parameters return correct results by @jerrinot in https://github.com/questdb/questdb/pull/6453
• feat(sql): weighted average and standard deviation by @mtopolnik in https://github.com/questdb/questdb/pull/6457

Full Changelog: https://github.com/questdb/questdb/compare/9.2.1...9.2.2