April 2019 Summaries

CockroachDB 19.1 is the latest release from Cockroach Labs, designed to enhance distributed SQL capabilities and offer robust enterprise-grade features for improved security and data integration. This version introduces several SQL enhancements, including a new cost-based optimizer with support for join hints and reverse index scans, which allow users to optimize query performance. The release also features automatic statistics collection to streamline query optimization and a web UI for visualizing logical query plans. To cater to enterprise demands, CockroachDB 19.1 includes advanced change data capture (CDC) capabilities that facilitate seamless data flow into various backend systems and provides enhanced security measures such as single sign-on integration and data encryption at rest. Overall, this update aims to improve scalability, efficiency, and security for distributed applications while maintaining compatibility with enterprise infrastructure.

Raphael 'kena' Poss delves into why Go executable files, such as those used in CockroachDB, are unexpectedly large, despite smaller increases in source code size. He created a visualization tool using D3 tree maps to explore the contents of Go binaries, revealing that a significant portion of the size increase is due to the `runtime.pclntab` object, which supports runtime stack trace generation and grows super-linearly with the number of functions. Originally intended to improve start-up times, this design choice from Go 1.2 is less beneficial for long-running server software like CockroachDB, where the increased binary size poses distribution and deployment challenges. The tool, available on GitHub, highlights other inefficiencies such as unused interface conversion tables and type functions that persist in the binaries, suggesting a need for optimization in Go's compilation process to better suit large-scale applications.