Benchmarking Complex Query Performance in CrateDB and PostgreSQL
In this post we put together a benchmark that compares CrateDB v.1.14 versus PostgreSQL v9.6 performance in terms of query throughput and query time.
CrateDB Scalability Benchmark: Query Throughput
This post describes a query throughput benchmark showing how CrateDB provides linear improvements in query throughput as the cluster grows.
Achievement Unlocked: CrateDB 1.0
CrateDB 1.0 is available with improved performance and a host of new features for the distributed open source SQL database.
Release: Crate 0.41.0 (Testing)
CrateDB Version 0.41.0 comes with a brand new set of arithmetic functions for you to crunch and squeeze all the numbers from your tables.
Upgrade Your Cluster to 0.55.x
Crate Version 0.55 introduces a lot of great features, fixes and changes. Some of these required making changes to our code base that require extra steps to upgrade your clusters than with previous Crate versions.
Crate 0.55, Our Biggest Release Yet?
Crate is regularly updated, so we don't normally write a blog post for each release, but our forthcoming 0.55 release is so chock-full of features that we felt it deserved something special.
Bulk Inserts with unnest
CrateDB 0.55 introduces support for unnesting. Unnest uses arrays to generate a transient table with each array representing a column.
PHP 7 Support
We are excited to announce that crate-pdo and its ORM Layer crate-dbal now support PHP 7.
Generated Columns in Crate 0.54.0
Announcing the support of generated columns in CrateDB 0.54.0. The idea behind generated columns is to have values computed from generation expressions
Improving on Joins
We've doubled the JOINs performance for almost all queries, and removed many of the previously existing restrictions.