7.3.5

What's Changed

Following up our recent 7.3.4 release which provided Window Functions, Web Console improvements, and more, we're pleased to announce another significant release. Headlining 7.3.5 are the following key additions:

• Percentile function: Find an approximate percentile for a given series with approx_percentile(DD).
• Optimized queries: QuestDB has long stood out for its high performance ingestion. Not be left behind, queries also keep getting faster. In benchmarks, recent performance optimizations have shown 50% improvement to several query types.

New features

• feat(core): config to limit RSS memory used for writing by @ideoma in #3937
• feat(core): print insufficient Linux kernel limits on start-up by @puzpuzpuz in #3980
• feat(sql): implement approx_percentile function by @kevinmingtarja in #3900
• feat(sql): string_agg function support in keyed group by queries by @puzpuzpuz in #3991
• feat(sql): add first_not_null and last_not_null functions for GeoHash and IPv4 data types by @bziobrowski in #3929
• feat(sql) add show server_version by @nitram509 in #3901
• feat(sql): add show parameters SQL by @bluestreak01 in #3972
• perf(sql): optimize count_distinct symbol function by @puzpuzpuz in #3974

Fixes and improvements

• fix(sql): fix segfault in aggregate vectorized functions on zero input length by @puzpuzpuz in #3944
• fix(sql): maintain timestamp metadata in window factories by @bziobrowski in #3940
• fix(core): introduce separate settings for WAL writer pool by @puzpuzpuz in #3948
• fix(sql): improve count(*) and limit x,y performance by @bziobrowski in #3951
• fix(sql): fix create table like with dedup by @brunocalza in #3964
• fix(sql): fix several small sql issues by @bziobrowski in #3970
• fix(core): fix UPDATE timeout can leave non-WAL table in half updated state by @ideoma in #3946
• fix(core): reduce disk and memory footprint of system tables by @puzpuzpuz in #3945
• fix(core): recognize XFS file system as supported by @puzpuzpuz in #3968
• fix(core): handling of unexpected errors in SQL execution by @glasstiger in #3963