Lab Notes

Lab Notes

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part Three

2018-08-28

The final part of a three-part miniseries that looks at how we improved join performance in the CrateDB 3.0 release.

Read more

Lab Notes

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part Two

2018-07-03

Part two of a three-part miniseries that looks at how we improved join performance in the CrateDB 3.0 release.

Read more

Lab Notes

Lab Notes: How We Made Joins 23 Thousand Times Faster, Part One

2018-06-26

Since many CrateDB users want to run joins on large tables for their analytics, we decided to introduce a new join algorithm that would have better join performance than the nested loop algorithm. In this post, I will show you how we approached the problem.

Read more

Lab Notes

Lab Notes: Adding Support for Joins on Virtual Tables and Multi-Row Subselects

2018-04-30

In a recent batch of work, we added support for joining on virtual tables, and support for multi-row subselects. That work is available in the latest CrateDB. In this post, I will introduce you to both concepts, explain the challenges...

Read more

Lab Notes

Lab Notes: Extending Support for Scalar Subqueries

2018-02-09

In this post, I will introduce scalar subqueries, explain what challenges we faced extending this feature in CrateDB, and then show you how we addressed those challenges.

Read more

Lab Notes

Lab Notes: Implementing Non-Collapsable Subselects

2017-10-19

CrateDB now supports non-collapsable subselects. Let us introduce you to the problem, and show you the steps Crate.io took to solve it.

Read more

Lab Notes

Lab Notes: Query Execution Pipeline Overhaul

2017-04-04

The past couple of weeks my team and I have spent some time overhauling the execution pipeline. In this post, I’ll briefly introduce you to the problem we were trying to solve, and how we went about solving it.

Read more