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.
Table of contents
Performance and resilienceSQL and PostgreSQL compatibilitySQL functions and statementsA note on type validationExternal contributions39.7K Impressions