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.
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.
This post describes a query throughput benchmark showing how CrateDB provides linear improvements in query throughput as the cluster grows.
CrateDB 1.0 is available with improved performance and a host of new features for the distributed open source SQL database.
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.
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 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.
CrateDB 0.55 introduces support for unnesting. Unnest uses arrays to generate a transient table with each array representing a column.
We are excited to announce that crate-pdo and its ORM Layer crate-dbal now support PHP 7.
Announcing the support of generated columns in CrateDB 0.54.0. The idea behind generated columns is to have values computed from generation expressions
We've doubled the JOINs performance for almost all queries, and removed many of the previously existing restrictions.