--- title: New Release: CrateDB 6.5 | daily.dev description: CrateDB 6.5 speeds up aggregations, GROUP BY queries, and query planning, and improves PostgreSQL compatibility. A count(DISTINCT col) rewrite made certain... canonical: https://daily.dev/posts/new-release-cratedb-6-5-mm3r1dg6t twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: New Release: CrateDB 6.5 | daily.dev og:description: CrateDB 6.5 speeds up aggregations, GROUP BY queries, and query planning, and improves PostgreSQL compatibility. A count(DISTINCT col) rewrite made certain... og:url: https://daily.dev/posts/new-release-cratedb-6-5-mm3r1dg6t og:image: https://api.daily.dev/og/posts/mm3r1DG6t.png og:image:alt: New Release: CrateDB 6.5 og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # New Release: CrateDB 6.5 **[CrateDB](https://daily.dev/sources/cratedb)** · 5 min read · 0 upvotes · 0 comments ## Summary CrateDB 6.5 speeds up aggregations, GROUP BY queries, and query planning, and improves PostgreSQL compatibility. A count(DISTINCT col) rewrite made certain queries up to 21x faster in benchmarks, cutting one real query from 8,293 ms to about 397 ms. GROUP BY on string columns with doc values saw a performance increase of more than 100% in tests, and keys-only GROUP BY on high-cardinality text columns is 41% faster in one benchmark. The release also adds pg_is_in_recovery(), a date column type, OpenID Connect Discovery for JWT auth, and makes SWAP TABLE and RENAME TABLE safer during concurrent operations and snapshots. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How much faster is count(DISTINCT col) in CrateDB 6.5 compared to earlier versions? Up to 21 times faster in benchmarks. CrateDB 6.5 rewrites a count(DISTINCT col) query without GROUP BY on a string column into an internal grouping operation. In a real example, a query against a 'cCode' column dropped from 8,293 ms average execution time to around 397 ms after the rewrite. _Teams tuning dashboard query latency can track releases like this one on daily.dev._ ### Does CrateDB 6.5 make GROUP BY queries on text columns faster? Yes. Keys-only GROUP BY queries on text columns without a filter now use the Lucene term dictionary, cutting execution time by 41% for high-cardinality columns in benchmarks. GROUP BY queries on string columns with doc values enabled also saw a performance increase of more than 100% by reading values directly from doc values. _Engineers optimizing dashboard filter and dropdown queries can follow database performance updates on daily.dev._ ### Does CrateDB support OpenID Connect Discovery for JWT authentication? Yes, as of CrateDB 6.5. CrateDB can automatically fetch the identity provider's configuration using OpenID Connect Discovery, reducing manual setup and maintenance for JWT authentication, including handling cases where signing keys get rotated. _Developers configuring JWT auth for their database can track changes like this on daily.dev._ ## Similar posts on daily.dev - [ClickHouse Release 26.7](https://daily.dev/posts/clickhouse-release-26-7-8dsprk7ep) · ClickHouse · 3 upvotes · 0 comments - [SQL Improvements in PostgreSQL 11–18: A Personal Selection](https://daily.dev/posts/sql-improvements-in-postgresql-11-18-a-personal-selection-hujlsgrj1) · Planet PostgreSQL · 0 upvotes · 0 comments - [ClickHouse Release 26.4](https://daily.dev/posts/clickhouse-release-26-4-9kszqbsdn) · ClickHouse · 7 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#sql](https://daily.dev/tags/sql), [#postgresql](https://daily.dev/tags/postgresql), [#cratedb](https://daily.dev/tags/cratedb) [View this post on daily.dev](https://daily.dev/posts/new-release-cratedb-6-5-mm3r1dg6t) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"New Release: CrateDB 6.5","url":"https://daily.dev/posts/new-release-cratedb-6-5-mm3r1dg6t","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/new-release-cratedb-6-5-mm3r1dg6t"},"datePublished":"2026-10-28T14:24:12.125Z","dateModified":"2026-10-28T15:04:32.995Z","description":"CrateDB 6.5 speeds up aggregations, GROUP BY queries, and query planning, and improves PostgreSQL compatibility. A count(DISTINCT col) rewrite made certain...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/e62fa1f485e9bda3dcce565bb6d68a0d?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/e62fa1f485e9bda3dcce565bb6d68a0d?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"CrateDB","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"CrateDB","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/46d00ffb81d0452e90976cc491162d6e","url":"https://daily.dev/sources/cratedb"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/new-release-cratedb-6-5-mm3r1dg6t","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,sql,postgresql,cratedb","timeRequired":"PT5M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"CrateDB","item":"https://daily.dev/sources/cratedb"},{"@type":"ListItem","position":3,"name":"New Release: CrateDB 6.5"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/new-release-cratedb-6-5-mm3r1dg6t#faq","mainEntity":[{"@type":"Question","name":"How much faster is count(DISTINCT col) in CrateDB 6.5 compared to earlier versions?","acceptedAnswer":{"@type":"Answer","text":"Up to 21 times faster in benchmarks. CrateDB 6.5 rewrites a count(DISTINCT col) query without GROUP BY on a string column into an internal grouping operation. In a real example, a query against a 'cCode' column dropped from 8,293 ms average execution time to around 397 ms after the rewrite. Teams tuning dashboard query latency can track releases like this one on daily.dev."}},{"@type":"Question","name":"Does CrateDB 6.5 make GROUP BY queries on text columns faster?","acceptedAnswer":{"@type":"Answer","text":"Yes. Keys-only GROUP BY queries on text columns without a filter now use the Lucene term dictionary, cutting execution time by 41% for high-cardinality columns in benchmarks. GROUP BY queries on string columns with doc values enabled also saw a performance increase of more than 100% by reading values directly from doc values. Engineers optimizing dashboard filter and dropdown queries can follow database performance updates on daily.dev."}},{"@type":"Question","name":"Does CrateDB support OpenID Connect Discovery for JWT authentication?","acceptedAnswer":{"@type":"Answer","text":"Yes, as of CrateDB 6.5. CrateDB can automatically fetch the identity provider's configuration using OpenID Connect Discovery, reducing manual setup and maintenance for JWT authentication, including handling cases where signing keys get rotated. Developers configuring JWT auth for their database can track changes like this on daily.dev."}}]} ```