This article explains how to measure, analyze, and improve CPU usage in software by examining key metrics, choosing efficient algorithms and data structures, leveraging compiler options, exploiting cache behavior and SIMD vectorization, and applying practical case studies with Linux profiling tools.
The article examines three modern, cloud‑native and open‑source methods for deploying PostgreSQL—using the CloudNativePG operator on Kubernetes, leveraging Korifi’s self‑service platform, and adopting Neon’s compute‑storage separation—highlighting trends toward cloud‑native infrastructure, self‑service, and open‑source SaaS alternatives.
A segmentation fault in a simple tile‑index copy loop was traced to GCC 9.2’s -O3 loop‑vectorization pass miscalculating structure offsets, and the issue was resolved by disabling -ftree-loop-vectorize or upgrading the compiler, as newer GCC versions and Clang handle the code correctly.
A client‑reported segmentation fault was traced to changing GCC’s optimization level from -O2 to -O3, revealing a bug in the -ftree-loop-vectorize option that miscalculates struct sizes, and the article explains the analysis, assembly inspection, NEON details, and a practical workaround.
The article reviews the cooling of 2022 database funding, highlights Velox as a shared execution engine, examines ReadySet's transparent caching, profiles Neon’s serverless PostgreSQL, surveys other notable databases, and outlines emerging trends and predictions for 2023, offering a comprehensive technical and market analysis for developers and DB professionals.
This article details the engineering optimizations applied to the image cropping stage of Kuaishou's YKit AI SDK, covering instruction-level fixes, SIMD acceleration, I/O cache improvements, algorithmic refinements, parallel processing, and device‑tier strategies to achieve up to 4.6× speedup on mobile devices.
