Earlier I had written a blog about partition-wise join in PostgreSQL. In that blog I had talked about an advanced partition matching technique which will allow partition-wise join to be used in more cases. In this blog we will discuss this technique in detail. I will suggest to read my blog on basic partition-wise join again to get familiar with the technique.| Walking with the Elephants
Cost based optimization| Walking with the Elephants
Unlike inheritance-based partitioning, declarative partitioning introduced in PostgreSQL 10 leaves nothing to infer about how the data is divided into partitions. PostgreSQL 11's query optimizer is gearing up to take advantage of this "no-inference" representation. The first one that got committed was basic partition-wise join.| Walking with the Elephants
I published an article on the Cockroach Labs Blog: On the Way to Better SQL Joins in CockroachDB. In this article, I explain how I improved the first design of SQL joins in CockroachDB to support basic forms of optimizations in CockroachDB v1.0. Also available via the Wayback Machine …| dr knz @ work
I published an article on the Cockroach Labs Blog: Modesty in Simplicity: CockroachDB’s JOIN. In this article, I explain how I designed the first (and overly simplistic) implementation of SQL joins prior to CockroachDB v1.0. Also available via the Wayback Machine.| dr knz @ work