---
title: "New Release: CrateDB 6.4"
url: https://daily.dev/posts/new-release-cratedb-6-4-i19xpjbb7
source_url: https://cratedb.com/blog/new-release-cratedb-6.4
type: article
source: "CrateDB"
published: 2026-07-20T11:34:01.535Z
updated: 2026-07-20T11:34:21.891Z
tags: ["data-science", "backend", "sql", "postgresql", "cratedb"]
reading_time: 4
upvotes: 16
comments: 0
language: 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.4

**[CrateDB](https://daily.dev/sources/cratedb)** · 4 min read · 16 upvotes · 0 comments

## Summary

CrateDB 6.4 has been released with a focus on performance, resilience, and PostgreSQL compatibility. Key highlights include GROUP BY queries up to 140% faster, improved aggregation performance on varchar columns, and the to_char() function being 25% faster. PostgreSQL compatibility improvements include the addition of pg_catalog.pg_user, pg_get_constraintdef(), information_schema.collations, and a new regtype data type. New SQL features include the largest triangle three buckets (LTTB) aggregation function for downsampling time-series data, the BLAKE3 scalar function for checksums, and the ALTER REPOSITORY statement. A breaking change in type validation for INSERT INTO makes behavior consistent across single and multi-row inserts.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://cratedb.com/blog/new-release-cratedb-6.4>

## Similar posts on daily.dev

- [New release: CrateDB 6.3](https://daily.dev/posts/new-release-cratedb-6-3-szft7ac8t) · CrateDB · 0 upvotes · 0 comments
- [New release: CrateDB 6.2](https://daily.dev/posts/new-release-cratedb-6-2-bn0wmdank) · CrateDB · 1 upvotes · 0 comments
- [New Release: CrateDB 6.0](https://daily.dev/posts/new-release-cratedb-6-0-brmfqilav) · CrateDB · 64 upvotes · 0 comments

---

Tags: [#data-science](https://daily.dev/tags/data-science), [#backend](https://daily.dev/tags/backend), [#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-4-i19xpjbb7)